topic Re: What is the difference between using “=” before a variable and when it is not used? in QlikView

What is the difference between using “=” before a variable and when it is not used?

manozpph — Tue, 02 Sep 2014 21:19:25 GMT

Hey Guys Can Some body Let me know the Answer for this Question.

What is the difference between using “=” before a variable and when it is not used?

Thanks In Advance!

jagan — Wed, 03 Sep 2014 02:09:35 GMT

Hi,

Giving = in variable will evaluate the expression and stores the result in variable, if we do not give = then the expression is stored as string.

For example:

vSales : =Sum(Sales) - then Total sales is calculated (Assume total sales is 1 Million)

vSalesExpression : Sum(Sales) - this will store Sum(Sales) as string

Now in a chart if you have a dimension Customer and use the above expression

=$(vSales) - for all the customers you will the same sales amount 1 Million, since it is already evaluated.

=$(vSalesExpression ) - will calculate the sales for each customer, $(vSalesExpression ) will simply put Sum(Sales).

Hope this helps you.

Regards,

Jagan.

jagan — Wed, 03 Sep 2014 02:10:21 GMT

Hi,

check this links, hope it helps you.

Regards,

Jagan.

manozpph — Wed, 03 Sep 2014 04:46:09 GMT

I have gotten the Answer.

Thank you so much for your help.