Column() function

[#1]

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

[#2 · Accepted solution]

You can probably use 1 if to check if the sum of those columns is 0 (using sum or rangesum)

[#3]

Thank you for your help!

[#4]

You're welcome! Happy QlikViewing!