topic Re: Aggr function question in QlikView

Aggr function question

john_duffy — Fri, 22 Mar 2013 15:53:38 GMT

Hello all.

I'm having an issue with an aggr/sum expression.

In the attached QlikView application you will see that I two charts - Test Aggr and Test.

When no selections are made in the Region listbox, the two charts are displaying the information correctly.

When a Region is selected (eg. North), the Test chart remains unchanged. This is correct. The Test Aggr chart is reduced to only the Comp/Dept combinations that have a value for the North Region. I do have the condition [Region]= in both expression sets.

What I want is neither chart to change when a Region is selected.

Any help will be greatly appreciated.

Regards,

John.

Re: Aggr function question

Fri, 22 Mar 2013 16:02:15 GMT

in the chart "Test aggr" change your expression in

only({$<[Region]=>}aggr(nodistinct sum({$<[Region]=>} total <[Comp]>[Cnt]),[Comp]))

and it works!

Re: Aggr function question

john_duffy — Fri, 22 Mar 2013 17:05:59 GMT

Thank you very much.

Can you give me a brief explanation as to why the only function is required.