Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
DanRonsman
Contributor
Contributor

Limiting Results in a Straight Table

I have a straight table with 5 columns. I expression for each column. I want to be able to limit the results(rows) in the table based on criteria from 2 of the columns. For example my table contains a row for each zip code. Column 1 contains the sum of providers in that zip code and column 2 contains the sum of claims for that zip code. I want to be able to limit the table to show only zip codes that have more than 25 providers and more than 100 claims. 

1 Reply
MayilVahanan

Hi @DanRonsman 

Try like below in the dimension 

Aggr(If(Sum(Providers)>25 and Sum(Claims)>100, ZipCode), ZipCode)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.