Functions

[qlikview979]

Hi experts,

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

[Oleg_Troyansky]

Hi Mahesh,

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

[hari8088]

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.

[qlikview979]

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

[Oleg_Troyansky]

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

NEXT

cheers,

Oleg Troyansky

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

[Anonymous]

Hi Mahesh,

Functions in QlikView

[Anonymous]

Hi Mahesh,

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

Functions in QlikView

Hope it will helpful!!

[#8]

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.

[robert_mika]

Please see attached.

Sorted by groups with syntax's.

Some of them are explained in depth here:

How To /Missing Manual(18 articles)