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: 
datashaw
Contributor III
Contributor III

Set Analysis: syntaxes, examples

Please correct me the below expression  for the  Qlik Sense KPI. 

 

1. Count({<STATUS -={'REJECTED'}, TYPE ={'RTP'} ,TYPE =  {'ITP'}>}  TextValue)

2.  Count({<STATUS -={'REJECTED'}, TYPE ={'RTP'   ,    'ITP'}>}  TextValue)

 

I'm getting two different results for the above expression. please correct me which one is accurate

 

Column 'TYPE. = RTP, ITP, DPI, FTP

Labels (1)
1 Solution

Accepted Solutions
Lauri
Specialist
Specialist

In #1, you are requiring TYPE to be equal to RTP and ITP, which is (probably) impossible for any given row. In #2, you are requiring TYPE to be equal to RTP or ITP.

View solution in original post

1 Reply
Lauri
Specialist
Specialist

In #1, you are requiring TYPE to be equal to RTP and ITP, which is (probably) impossible for any given row. In #2, you are requiring TYPE to be equal to RTP or ITP.