
Contributor III
2020-05-22
07:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
1,143 Views
1 Solution
Accepted Solutions

Partner - Creator
2020-05-22
07:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=If(GetSelectedCount(DIRECT_INDIRECT) = 1, 0, 1)
2 Replies

Partner - Creator
2020-05-22
07:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=If(GetSelectedCount(DIRECT_INDIRECT) = 1, 0, 1)

Contributor III
2020-05-30
01:40 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thank you . It works. 🙂
1,098 Views
