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: 
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)