Discussion Board for collaboration related to QlikView App Development.
I have an if statement that works fine:
Do you have any suggestions of how to write this in a shorter way?
Cant do a rangemax(C0,.....,C10)=C0 because sometimes C0=C1 (or other) and the condition is not correct.
Go to Solution.
May be like:
If( C0>RangeMax(C1,C2,...C10), 1,0)
View solution in original post
This works! I didn't think of this. Haha.
But. My condition with C0>C1.... will also give me a 0 when one of the values is null(). Is there a way of taking care of null values?
Yes, you may try like:
If( C0>RangeMax(C1,C2,...C10) OR IsNull(C1+C2+...C10), 1,0)