Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Correct the parentheses and use a sum:
Sum(if(amount > highlimit, 1, 0))
^ ^ ^
Correct the parentheses and use a sum:
Sum(if(amount > highlimit, 1, 0))
^ ^ ^