Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator III
Creator III

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
Highlighted
Creator III
Creator III

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