Discussion board where members can get started with Qlik Sense.
I am trying to count a range of value if it's different then the value 'OF CLOS' that is in other column.
Count(DISTINCT If(([OF CLOS & OF OF OUV]<>'OF CLOS'), [Nº rés. & Pos _ Base _ Duplicata]))
It's the symbole <> that isn't working.
Thang you in advance for your help.
Best regards, Arun
What do you mean with a range of values? Can you show us a screenshot of the table?
The If should be outside of the count statement.
IF( [OF CLOS & OF OF OUV]<>[OF CLOS], Count([Nº rés. & Pos _ Base _ Duplicata])
It's not working...
The result is this '-'