topic Re: expression how it works? in QlikView

expression how it works?

Anonymous — Wed, 24 Sep 2014 06:26:22 GMT

='Sales : ' & Num(Sum(Sales), '#,##0')

Re: expression how it works?

PrashantSangle — Wed, 24 Sep 2014 06:29:28 GMT

Hi,

Num() is formated your output of Sum(Sales) in Integer format

and Sales is text appended using & special character.

& work as concat two fields.

Regards

Re: expression how it works?

crusader_ — Wed, 24 Sep 2014 06:29:44 GMT

Hi,

Text (Sales : ) + Sum(sales) in format '#,##0'

Hope this helps.

Andrei

Re: expression how it works?

Wed, 24 Sep 2014 06:29:54 GMT

you having sales data

first it is performing sum of data then whatever data comes as result on that resultant data again you are performing num with specific format which you are assigning in second parameter .