topic Re: How to write set expression in load script in QlikView

How to write set expression in load script

Wed, 22 Jun 2016 14:50:50 GMT

HI all,

can anyone please help me, how to write a set expression in load script.. I have an sql query in which a field value realtime has the values from three different Tags. usually, i use the below set expression

Expresion : Sum({$<TagName={fillA}>}realTime)

to get the value corresponding to each Tag.. Usually, I used to assign this expression to the variable in the variable overview window. But, now i want to calculate this expression in script and than i have to use that value in other variable and the resulting value should be assign to the variable.

so i want that to be done in load script.

In the community, i read about using of some flags to achieve this, but i couldn't understand that.. can any one please help me with this ..

Thank you

Ganesh

Re: How to write set expression in load script

CELAMBARASAN — Wed, 22 Jun 2016 14:54:20 GMT

Set Analysis cannot be used in Load Script. It will be applied in visualization parts.

May be for your case you could use Where condition to restrict in script.

Try something like below

Load Field1, Sum(realTime) AS RealTime

Resident Table Where TagName=fillA;

Re: How to write set expression in load script

Anonymous — Wed, 22 Jun 2016 14:57:16 GMT

HI Ganesh,

You cannot use set analisys on script.

You can write it like this Sum(IF(TagName='fillA',realTime)) as realTimefillA

Regards!

Re: How to write set expression in load script

Thu, 23 Jun 2016 10:13:23 GMT

Thank you celambrasan... It is really helpful for me

Re: How to write set expression in load script

Thu, 23 Jun 2016 10:14:26 GMT

Thank you for the expression, i used this expression to get the field value..its really helpful for my problem