Limit rows in Qliksense straight table based on a Measure

[sheschro]

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!

[lironbaram · Accepted solution]

hi 

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 

[sheschro]

Thank you! That works beautifully.