9 Replies Latest reply: Oct 23, 2012 5:21 PM by Stefan Wühl RSS


    Francesco Carmellini

      hello everybody.

      my question: let's say i have a database with 6 coloumns (i.e. 6 fields) F1, F2, F3, ..., F6 and a N number of entries (rows). i'd like to count any row ONLY IF each one contains a value greater than X. if i was in MS Excel i'd write a formula in a seventh coloumn/field like this: =IF(OR(F1,1>X; F2,1>X);1;0).

      how can i translate this in a Qlik expression?

      i tried searching the guide but i didn't find anything helpful for me...