topic Is there any difference between Let vSales2 = '=Sum(Sales)' and Let vSales2 = 'Sum(Sales)' and Let vSales2 = Sum(Sales) ?? in QlikView

Is there any difference between Let vSales2 = '=Sum(Sales)' and Let vSales2 = 'Sum(Sales)' and Let vSales2 = Sum(Sales) ??

nikhilgarg — Thu, 25 Sep 2014 11:38:00 GMT

Hey,

Is there any difference between :

Let vSales2 = '=Sum(Sales)' and Let vSales2 = 'Sum(Sales)' and Let vSales2 = Sum(Sales) ??

Thanks

Thu, 25 Sep 2014 11:44:39 GMT

Hi Nikhil,

LET indstruction will load the content of the expression you give.

so if sum(Sales) = 10

LET vSales2 = '=sum(Sales)' will return '=10'

LET vSales2 = 'sum(sales)' will return 10

I would say you use either

LET vSales2 = 'sum(sales)' will return 10

SET vSales2 = '=Sum(Sales)' will store vSales2 as a string '=sum(sales)' which will be evaluated later

best regards

Chris

ashfaq_haseeb — Thu, 25 Sep 2014 11:48:11 GMT

Hi Niklil

Check this

Regards

ASHFAQ