topic Re: Variable value in QlikView

Variable value

gouthamkk — Wed, 25 Jun 2014 14:21:09 GMT

Hi Experts,

In the backend scripting, I would like to get count of distinct id into a variable. Can some one help me in getting it?

Eg:

Load Count(distinct(id) as flag;

sql select * from demo;

Till here every thing is fine.

No I need to save the flag values in a variable

Request to assist

Thanks Kumar

Re: Variable value

Gysbert_Wassenaar — Wed, 25 Jun 2014 14:38:25 GMT

Load Count(distinct(id) as flag;

sql select * from demo;

LET vCount = peek('flag');

But you don't need to do it this way. Qlikview keeps track of distinct values of its internal tables and there are (very fast) functions to use such information:

sql select * from demo; // this assumes you load a field called id.

LET vCount = fieldvaluecount('id'); // get the number of distinct values from Qlikviews internal field tables.

Re: Variable value

gouthamkk — Wed, 25 Jun 2014 14:52:57 GMT

HI,

Thanks a lot for the additional input. I think I will go with your second thought on Internal tables. Both the logics works fine and are giving same results

thanks

Kumar