Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Limit rows in Qliksense straight table based on a Measure

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!

Labels (3)
1 Solution

Accepted Solutions
Partner
Partner

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 

View solution in original post

2 Replies
Partner
Partner

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 

View solution in original post

Contributor
Contributor

Thank you! That works beautifully.