topic Re: Functions in QlikView

Functions

qlikview979 — Sat, 27 Jun 2015 15:34:53 GMT

Hi experts,

What are the functions we are using in script level? explain with example?

Re: Functions

Oleg_Troyansky — Sat, 27 Jun 2015 15:39:07 GMT

Hi Mahesh,

there are hundreds of functions that we use... open Help and search for functions. You will find hundreds of examples.

Re: Functions

hari8088 — Sat, 27 Jun 2015 15:46:16 GMT

Hi Mahesh

We can use all functions like string,numeric,file,conditional,....etc functions except field functions like getcurrentselections,getpossiblecount,getexcludecount,getfieldselections....etc.......these functions we can use in ui level.

for example if u have chart in that you want to know currently selected one then use the function in ui getcurrentselections(expression) then it will give the currently selected field.These functions will not work in script level.

Re: Functions

qlikview979 — Sat, 27 Jun 2015 15:47:03 GMT

can you give one example for me? in script level .

Re: Functions

Oleg_Troyansky — Sat, 27 Jun 2015 15:57:36 GMT

Here is an example from my new book. In this example, we query the database for the list of tables and then process all tables one by one in a FOR loop. In this example, we use the peek() function to fetch the data from a table:

Tables:

sqltables;

FOR vRow = 0 TO NoOfRows('Tables') - 1

IF peek('TABLE_TYPE', vRow, 'Tables') = 'TABLE' THEN

let vTable = peek('TABLE_NAME', vRow, 'Tables');

call GenerateQVD(vTable, vQVDPath);

END IF

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

Re: Functions

Anonymous — Sat, 27 Jun 2015 16:54:23 GMT

Hi Mahesh,

Functions in QlikView

Re: Functions

Anonymous — Sat, 27 Jun 2015 16:56:24 GMT

Hi Mahesh,

Go through this link ( Thread)......You can learn and easily understand QV functions.

Functions in QlikView

Hope it will helpful!!

Re: Functions

Sat, 27 Jun 2015 17:15:14 GMT

Hi Mahesh,

Open a new Qlikview document, click on help, then qlikviewhelp window opens on Index tab search "Script Functions". you will find all the script functions over there, by clicking on each function you will find its definition, syntax with examples. I hope this helps you.

Re: Functions

robert_mika — Sat, 27 Jun 2015 20:49:19 GMT

Please see attached.

Sorted by groups with syntax's.

Some of them are explained in depth here:

How To /Missing Manual(18 articles)