Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Following from https://community.qlik.com/message/1377067?et=watches.email.thread#1377067
where
I had a table
and I would like to show only rows where 2 or 3 of the columns are not null (in other words to exclude rows with 2 or more null)
so expecting to see:
using Sunny's solution I am Now trying to count in a Text Object how many lines are matching 2 or 3 conditions - so how many are in the solution: here for example A+D+F+I+K = 5
so I will expect to see 5 in the text Object.
Any idea,
Thanks.
Raphael
May be try this
=Count(DISTINCT If(RangeSum(If(Len(Trim(Cond1)) = 0, 1), If(Len(Trim(Cond2)) = 0, 1), If(Len(Trim(Cond3)) = 0, 1)) < 2, Letter))
or this
=Count(DISTINCT {<Letter = {"=RangeSum(If(Len(Trim(Cond1)) = 0, 1), If(Len(Trim(Cond2)) = 0, 1), If(Len(Trim(Cond3)) = 0, 1)) < 2"}>} Letter)
May be try this
=Count(DISTINCT If(RangeSum(If(Len(Trim(Cond1)) = 0, 1), If(Len(Trim(Cond2)) = 0, 1), If(Len(Trim(Cond3)) = 0, 1)) < 2, Letter))
or this
=Count(DISTINCT {<Letter = {"=RangeSum(If(Len(Trim(Cond1)) = 0, 1), If(Len(Trim(Cond2)) = 0, 1), If(Len(Trim(Cond3)) = 0, 1)) < 2"}>} Letter)
Both working perfect, many thanks
I would use the second expression if both of them works