Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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.