Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
gthomson4
New Contributor II

Set Analysis doesn't work

I have these two expressions in two single column tables - the tables return the same results for any and all selections on Region.

=Aggr({$} Country, Country)
=Aggr({1} Country, Country)  

I expected the 2nd table to include all countries regardless?

similarly for

=Aggr({1-$} Country, Country)

I would expect all countries not in the selection?

 

1 Reply
Partner
Partner

Re: Set Analysis doesn't work

Hi,

What happens when you try:

=Aggr({$} Sum(Sales), Country)
=Aggr({1} Sum(Sales), Country)  

Jordy

Climber 

Work smarter, not harder