Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlik Sense - ignoring SET expressions

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,

1 Solution

Accepted Solutions

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.

View solution in original post

3 Replies

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

Not applicable

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

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.

View solution in original post