Discussion Board for collaboration related to QlikView App Development.
Hi, I'm new to Qliksense and I have an issues comparing two fields to get the count valuesIn 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!
Correct the parentheses and use a sum:
Sum(if(amount > highlimit, 1, 0)) ^ ^ ^
View solution in original post