topic Re: variable in aggr in QlikView

variable in aggr

Tue, 07 Jun 2016 13:03:59 GMT

Hi,

I have an expression written in variable overview. I want to use this variable in 'calculated dimension' inside a chart.

For example, variable that I created: vSumOfAll = sum(x)+sum(y)

and I am using vSumOfall inside calculated dimension as :

rank(aggr($(vSumOfAll),[STATE]),4)

This shows an error. Any help on this is highly appreciated.

Regards.

Re: variable in aggr

cesaraccardi — Tue, 07 Jun 2016 13:11:17 GMT

In order to use a calculated dimension you need to wrap-up the expression with an aggr function, try moving the position of the ranking function:

aggr(rank($(vSumOfAll),4),[STATE])

Re: variable in aggr

Aurelien_Martinez — Tue, 07 Jun 2016 13:15:13 GMT

Hi,

If you do that :

aggr(rank($(vSumOfAll), 4), [STATE])

Aurélien

Re: variable in aggr

Tue, 07 Jun 2016 13:18:17 GMT

Thank you. It worked though it is difficult for me to understand why it worked this way. I thought rank was decided post aggregation and hence wrote the expression in that fashion. Thanks again..