Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
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.