Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
gthomson4
Contributor II
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
JordyWegman
Partner - Master
Partner - Master

Hi,

What happens when you try:

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

Jordy

Climber 

Work smarter, not harder