Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
how can I write an expression with column function to filter my date where columns n. 1, n. 5 and n. 9 aren't zero?
I could use a conditional expression like this:
If(column(1) = 0, If(column(5) = 0, If(column(9) = 0, 0, expression), expression), expression)
or there is another better way to write it?
Thanks in advance for your answers.
Andrea
You can probably use 1 if to check if the sum of those columns is 0 (using sum or rangesum)
You can probably use 1 if to check if the sum of those columns is 0 (using sum or rangesum)
Thank you for your help!
You're welcome! Happy QlikViewing!