Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prpranav
Contributor II
Contributor II

Display only rows with a small margin between their measures

Hey everyone!

I'm working with state voter data, and I'm trying to create a chart that shows only the counties with a vote count difference of 500 between the winner and runner up.

in the "show column if", I tried:

Max( aggr( sum([Candidate Votes]), Candidate)) - Max( aggr( sum([Candidate Votes]), Candidate),2) <500

But this does not create a visualization. Is there a way to show only the counties with a margin of 500?

Thank you!

0 Replies