Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.