topic Re: Function Master List in QlikView

Function Master List

Sat, 09 Nov 2013 17:12:50 GMT

Hi,

Does anyone know of a master list (like a cheat sheet) of QV functions? I want a quick reference so that I can become familiar at a high level with all available QV functions for both scripting and calculated expressions in charts.

Re: Function Master List

jonasheisterkam — Sat, 09 Nov 2013 17:40:45 GMT

You find all functions in the reference manuel, problem with all helping list is that you must order it, that way that you find functions where you not known the name in this moment.

In the QlikView help you can use search and must not know the exact name and you can find groups of functions. Tagging is in the help not the best but with the time you learn wich are the words you need to find functions for special use.

Re: Function Master List

Sat, 09 Nov 2013 23:40:39 GMT

Hi Chris,

You can check the complete reference under QlikView Help:

Click Contents > Script Management > Script Syntax (basically what you'll need is there and categorized).

Some good resources are also provided under Resource Library like:

QV10 Functions Cheatsheet.pdf

and String Functions

Re: Function Master List

rustyfishbones — Sun, 10 Nov 2013 09:33:57 GMT

Hi Chris,

I don't know of one for Functions, but there is one for Shortcuts

While in the Script Editor

Hold CTRL + Q+S+C and this will give you a list of handy Qlikview Shortcuts

Regards

Re: Function Master List

Sun, 10 Nov 2013 15:00:49 GMT

Very handy, thanks!

Re: Function Master List

Sun, 10 Nov 2013 15:01:05 GMT

Thanks for the help.

Re: Function Master List

rustyfishbones — Sun, 10 Nov 2013 15:02:07 GMT

Your Welcome!

Re: Function Master List

rustyfishbones — Sun, 10 Nov 2013 15:06:06 GMT

Chris,

You know you can also see the list of functions in the Expression Editor

Re: Function Master List

Sun, 10 Nov 2013 15:41:52 GMT

You can find different type of functions list in the Expression dialog box and find the description on the Help page