Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
in the chart "Test aggr" change your expression in
only({$<[Region]=>}aggr(nodistinct sum({$<[Region]=>} total <[Comp]>[Cnt]),[Comp]))
and it works!
in the chart "Test aggr" change your expression in
only({$<[Region]=>}aggr(nodistinct sum({$<[Region]=>} total <[Comp]>[Cnt]),[Comp]))
and it works!
Thank you very much.
Can you give me a brief explanation as to why the only function is required.