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...
These expressions are not equivalent, because the requirement is IMHO not clear.
Mine should return the count of records where all fields (F1 to F6) are showing values > X, while the set expression or the last one should return the count of records where any Field show a value larger X.
It's probably a matter of how to interprete the OP request. I was focusing on
"i'd like to count any row ONLY IF each one [added here: field] contains a value greater than X"
and interpreted this according to my first statement (all fields > X).
Looking at the Excel function, you might conclude something else.
i meant that i'd like to count a record (row) only if one or more fields contain values greater than X (X is a numeric value). thinking at the logical OR as a "+" and at the logical AND as a "*" i'd say Celambarasan Adhimulam's answer is the nearest to my need... but i'm gonna try and let you know...
no way, tried "copy and paste" with your formulas but none worked... i'd like to create an expression to use like a filter in a multibox object; i'd like this expression to count 1 if one or more fields of each row contains a value greather than given "X"... that's all, a logical "OR"...