Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

arun2305
New Contributor III

COUNT IF DIFFERENT

Hi,

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

 

3 Replies
Partner
Partner

Re: COUNT IF DIFFERENT

Hi 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]
)

Jordy

Climber

Work smarter, not harder
arun2305
New Contributor III

Re: COUNT IF DIFFERENT

Hi Jordy,

It's not working...

The result is this '-'

 

Employee
Employee

Re: COUNT IF DIFFERENT

Hello Arun,
Try using this set analysis expression instead of an IF statement
Count(Distinct {<[OF CLOS & OF OF OUV] -= {'OF CLOS'}>} [Nº rés. & Pos _ Base _ Duplicata])