topic Re: Aggragating variable in set analysis in QlikView

Aggragating variable in set analysis

Tue, 10 Jun 2014 13:26:06 GMT

Hello all,

I'm simply trying to use a variable (vCommissionableTotalSales) in my set analysis like this:

Sum({$<Month={'=Month(today())'}>} $(vCommissionableTotalSales))

...which gives me an error: Nested aggregation not allowed. Is this not possible to do?

Re: Aggragating variable in set analysis

MK_QSL — Tue, 10 Jun 2014 13:29:47 GMT

What is the definition of vCommissionableTotalSales?

Re: Aggragating variable in set analysis

Tue, 10 Jun 2014 13:30:42 GMT

Where are you using this expression?

Re: Aggragating variable in set analysis

Tue, 10 Jun 2014 13:32:03 GMT

vCommissionableTotals = Sum({$*BM13} [Sales Amount])

Re: Aggragating variable in set analysis

MK_QSL — Tue, 10 Jun 2014 13:34:53 GMT

Remove SUM

Only({$*BM13} [Sales Amount])

and try

Re: Aggragating variable in set analysis

Tue, 10 Jun 2014 13:41:40 GMT

Not sure if you meant "{$*BM13} [Sales Amount]" or "Only({$*BM13} [Sales Amount])", but I tried both as the variable definition. The first gave an error and the second returned null.

Re: Aggragating variable in set analysis

MK_QSL — Tue, 10 Jun 2014 13:42:37 GMT

My Mistake,,,, Only will not work here... will check and come back to you on this

Re: Aggragating variable in set analysis

Tue, 10 Jun 2014 13:43:29 GMT

I'm actually trying to use this in a text box. In the full expression I'm adding "=" to the beginning.

Re: Aggragating variable in set analysis

Tue, 10 Jun 2014 17:39:21 GMT

I ended up just adding to my set analysis the criteria used in the variable's set analysis like so:

Sum({$*BM13<Month={$(=Month(Today()))}>}[Sales Amount])

Worked just fine. Just thought it'd be easier to use the variable.