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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Shoban_01
Partner - Contributor II
Partner - Contributor II

Exclude Condition in set analysis

what is a different between  

Count ({<Country =,year={'2015'}>} Client_ID)

and 
Count ({<Country ,year={'2015'}>} Client_ID)

and 

Count ({<Country -=,year={'2015'}>} Client_ID)

 

Labels (4)
2 Solutions

Accepted Solutions
rwunderlich
MVP
MVP

All three expressions are effectively the same. They all count Client_ID using a selection of year=2015. 

They all ignore any selections in field Country. They use different syntax to do so, but the effect is the same. 

I believe the preferred syntax is "Country=".

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

View solution in original post

filipemrabelo
Partner - Contributor II
Partner - Contributor II

You are right. The 3 expressions bring the same result. Sorry.asdasdasdasdasdsas.png

View solution in original post

3 Replies
filipemrabelo
Partner - Contributor II
Partner - Contributor II

.

rwunderlich
MVP
MVP

All three expressions are effectively the same. They all count Client_ID using a selection of year=2015. 

They all ignore any selections in field Country. They use different syntax to do so, but the effect is the same. 

I believe the preferred syntax is "Country=".

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

filipemrabelo
Partner - Contributor II
Partner - Contributor II

You are right. The 3 expressions bring the same result. Sorry.asdasdasdasdasdsas.png