I note regular requests on QlikCommunity for Qlikview keyboard shortcuts. The usual reply is to post a list of shortcuts.
One of the useful tips I picked up at the recent Masters Summit in London was the key sequence for displaying the list of keyboard shortcuts. In an editor — either script editor or expression editor:
<Ctrl>qsc
Keep the Ctrl key pressed, while sequentially pressing qsc.
-Rob
And if you think this is a very complex shortcut… Just think of:
QlikView ShortCut (CTRL+QSC)
Mathias
How timely 🙂
It’s still missing a shortcut for the OK/Cancel buttons on the expression editor 🙁
Interesting, it says that EDITOR_COMMENT is CTRL+K, but it doesn’t seem to work. Anyone else have any luck with that?
This is one of the most useful tips I have learned recently (and I assume this is a “hidden” feature known normally only to experienced developers).
Especially practical is the key combination at the end of the shortcut list: Ctrl+digits for entering special characters, which is very helpful when working on a keyboard with foreign layout and having a desperate need of these curly brackets in Set Analysis 🙂
(some keyboards really don’t have these characters)
Actually it is quite easy to remember: Ctrl-123 for the opening bracket and Ctrl-125 for the closing one.
“it says that EDITOR_COMMENT is CTRL+K, but it doesn’t seem to work”
You need to follow CTRL+K up with a CTRL+C to comment and CTRL+C to uncomment. Pretty complex shortcut..
CTRL+K followed by CTRL+U to uncomment, that is.
Hi Dipak,When the source tbeals don’t have a last updated date on them it is usually best to create a database trigger to create a separate table with ID and DateUpdated in that can then be joined to when doing the select. If the majority of rows never get updated in your database you could simply take rows with ID’s later than the last ID plus any with a version greater than one. This would only work if updates of previous rows were rare (eg. general ledger) as you would have to pull all amended rows on every run.Hope that helps.