topic Re: formula in variable on Variable Overview not working... in QlikView

formula in variable on Variable Overview not working...

Thu, 13 Nov 2014 09:37:20 GMT

Dear All,

i have a formula which i have to used many places in my Qlikview application the formula is : aggr((sum(TRADE_VALUE)/ count(DISTINCT TRADE_DATE))/10000000, MEMBER_NAME)

Now what i am thing that in Variable overview i had created a variable of above mention formula and want to use that variable to other places . but it is not working please help.

Is this because it is returning multiple records ??

Re: formula in variable on Variable Overview not working...

Gysbert_Wassenaar — Thu, 13 Nov 2014 10:59:16 GMT

aggr((sum(TRADE_VALUE)/ count(DISTINCT TRADE_DATE))/10000000, MEMBER_NAME)

If you don't use an aggregation function around this expression it would return a virtual table, possible with more than one row, i.e. more than one value. That's probably why it's not working in your case. Try using an aggregation function around it:

sum( aggr((sum(TRADE_VALUE)/ count(DISTINCT TRADE_DATE))/10000000, MEMBER_NAME) )

Re: formula in variable on Variable Overview not working...

Thu, 13 Nov 2014 11:14:40 GMT

HI Gysbert,

Thanks for you reply,

actually this formula i have to used in a Calculated Dimensional in many places so i want to make it as variable, and used it when needed in different different charts/tables.