topic Qlik Sense - ignoring SET expressions in App Development

Qlik Sense - ignoring SET expressions

Wed, 13 May 2015 15:30:30 GMT

Hello,

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

count({$<[CLAIMSTATUS_DESC]={'Approval'}>}distinct CLAIM_ID)

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!

Thanks,

Re: Qlik Sense - ignoring SET expressions

rubenmarin — Wed, 13 May 2015 15:35:00 GMT

Hi, please double-check field name [CLAIMSTATUS_DESC] and if that field really has an 'Approval' value with data.

Re: Qlik Sense - ignoring SET expressions

Wed, 13 May 2015 15:39:49 GMT

Hi Ruben,

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

Thanks

Re: Qlik Sense - ignoring SET expressions

rubenmarin — Fri, 15 May 2015 09:49:04 GMT

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.