Discussion board where members can learn more about Qlik Sense App Development and Usage.
I am using Qlik Sense 1.1
I have a measure expression in straight table as below to count only those claims that are approved
However the table is instead calculated for All claim status ignoring the SET criteria above. Is there anything obvious I am missing?
Appreciate your help!
Go to Solution.
Hi, please check this link: https://community.qlik.com/docs/DOC-7323/version/8
If it's because of direct query you'll need to change your expression avoiding set analysis, maybe adding flags to the records in script can help to obtain the desired results.
Hi, please double-check field name [CLAIMSTATUS_DESC] and if that field really has an 'Approval' value with data.
I've verified the column name as well as the value - no issues there.
Also the expression builder does not throw up error.
One item I forgot to mention. I am using Direct Query instead of cached tables in my sense app. I am not sure if this makes any difference