Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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
Partner Ambassador/MVP
Partner Ambassador/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
Partner Ambassador/MVP
Partner Ambassador/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