Qlik Community

Qlik Sense App Development

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

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
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

Re: Set Analysis: syntaxes, examples

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

Re: Set Analysis: syntaxes, examples

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