Aggr function question

[john_duffy]

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.

[#2 · Accepted solution]

in the chart "Test aggr" change your expression in

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

and it works!

[john_duffy]

Thank you very much.

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