topic Re: Limit rows in Qliksense straight table based on a Measure in App Development

Limit rows in Qliksense straight table based on a Measure

sheschro — Sat, 16 Nov 2024 07:12:33 GMT

New to Qlik Sense but familiar with Qlik View. I am trying to create a straight table that will show members with 5 or more maintenance drugs in a given time frame. In Qlikview I would write the following:

if(sum({<Maintenance={'Y'}>})CLM_COUNT)>4,1)

This does not work in Qlik Sense and I have not found a solution. Is it possible to show only rows where a sum is greater than a specific value in Qlik Sense?

Any help would be appreciated!

Re: Limit rows in Qliksense straight table based on a Measure

lironbaram — Tue, 27 Nov 2018 07:20:20 GMT

as Qlikview and Qliksense are sharing the same engine this expression should work in qlik sense

when you say it's not working what do you mean

does it return an error or the rows with zero still appear in the table

if it's the later than go to the table properties go to add-ons and uncheck the show zero values

Re: Limit rows in Qliksense straight table based on a Measure

sheschro — Tue, 27 Nov 2018 13:11:02 GMT

Thank you! That works beautifully.