Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
ArchanaB
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
whiteymcaces
Partner - Creator
Partner - Creator

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

View solution in original post

2 Replies
whiteymcaces
Partner - Creator
Partner - Creator

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

ArchanaB
Contributor III
Contributor III
Author

thank you . It works. 🙂