topic Re: Dynamic Aggregation in QlikView

Dynamic Aggregation

Tue, 29 Apr 2014 13:02:04 GMT

Hey guys:

based on user input I want to compute an average over a specific field:

Set vMenu = GetFieldSelections([Menu Item]); (will return Sales or Revenue or Profit..... and so on)

expression: =avg($(vMenu))

For some reason this does not work, even while $(vMenu) will return Sales

and avg(Sales) will also return a valid number.

Any ideas what might be happening?

MK_QSL — Tue, 29 Apr 2014 13:03:37 GMT

Try

expression: =avg($(=vMenu))

Tue, 29 Apr 2014 13:07:55 GMT

Nope, unfortunately

tresB — Tue, 29 Apr 2014 13:14:29 GMT

Could you post your sample app with the issue?

Tue, 29 Apr 2014 13:18:56 GMT

Yes, here is a demo app with public data.

tresB — Tue, 29 Apr 2014 13:21:20 GMT

Put '=' in variable definition. See attached.

Tue, 29 Apr 2014 13:24:45 GMT

Try =avg($(=$(vMenu)))

Tue, 29 Apr 2014 13:28:56 GMT

Try =avg($(=$(vMenu)))

I tested with selecting Sloop. it works. for other fields Menu list does not have corresponding same name in the fields..

Tue, 29 Apr 2014 13:47:31 GMT

Thanks, I had tried with '=', but I must have made some typo. Anyway, now it works:

set vMenu = ='[' & GetFieldSelections([Menu Item]) & ']';

tresB — Tue, 29 Apr 2014 13:49:25 GMT

Yes, that would be required for values with spaces in between.