Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Qliksense7
Contributor II
Contributor II

Couting greater than limits

Hi, 
I'm new to Qliksense and I have an issues comparing two fields to get the count values

In my datasets i have an amount variable and a high limit set for it. 

I used  the condition 
Count(if(amount) > [highlimit]),1,0)  but i'm getting an error. 
My goal is to find all the amount values greater than the high limit field and count each of those values as 1 

Thanks for the help!

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Correct the parentheses and use a sum: 

Sum(if(amount > highlimit, 1, 0))
                              ^                     ^        ^

 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

1 Reply
jonathandienst
Partner - Champion III
Partner - Champion III

Correct the parentheses and use a sum: 

Sum(if(amount > highlimit, 1, 0))
                              ^                     ^        ^

 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein