Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

If condition need to apply when all or none selected from filter

hi,

 

I am new to Qlik Sense. In my application , I have one filter named "DIRECT_INDIRECT" which filters on "DIRECT_INDIRECT" filed from Table. This filter only has two values "DIRECT" and "INDIRECT" .  I want to apply condition in KPI that when both value selected or none of the value is selected then it should one formula and one of the value selected then other formula

Basically I want to perform below action :

if(DIRECT_INDIRECT = none or DIRECT_INDIRECT= All , 1, 0)

Kindly please guide me for the same.  I tried using "ALL" or "none" in condition but it is not giving any output.

thank you in advance

 

 

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: If condition need to apply when all or none selected from filter

=If(GetSelectedCount(DIRECT_INDIRECT) = 1, 0, 1)

View solution in original post

2 Replies
Highlighted
Partner
Partner

Re: If condition need to apply when all or none selected from filter

=If(GetSelectedCount(DIRECT_INDIRECT) = 1, 0, 1)

View solution in original post

Highlighted
Contributor III
Contributor III

Re: If condition need to apply when all or none selected from filter

thank you . It works. 🙂