Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
shruthibk
Creator
Creator

How to use and condition in if statement

Hi ,

How can i use and condition in if condition?requirement is like,when they select  high and medium count should be 0 otherwisse

count({<rating={'low','TBD','very low'}>}ID) i tried if condition with and but whenever i am making selection of high and medium it is not showing 0

rating

high,

low,

medium,

TBD,

very low]

Please help me to resolve this.

Regards,

shruthi

10 Replies
qliksus
Specialist II
Specialist II

May be something like this

count({<Desc={"=match(Desc,'High','Med')=0 and GetSelectedCount(Desc)<=1"}>}Desc)