Count distinct but SUCCESS clients

[AlexWest]

Hi guys!

I have an excel file as a database in Qlik Sense.

And the excel file includes client IDs. They are have "falied" and "success" status.

But success client could be failed first and then he finished a registration.

When I try to DISTINCT Client IDs, Qlik sense kicks all of them. But I need to kick only those IDs that never wasn't SUCCESS.

Could you help me with that?

[rubenmarin · Accepted solution]

Hi, you can count all and substract the one with success:

Count(DISTINCT [Client ID])-Count(DISTINCT {<reg_Status={'Success'}>} [Client ID])

Or use the E() funtion to exclude clients with success:

Count(DISTINCT {<[Client ID]=E({<reg_Status={'Success'}>})>} [Client ID])

[AlexWest]

Thanks, Good man!

You are opened for me the E-function. It's very usefull.

But now I have a simular question but a little harder)

If you have time, please check if u could help with that?

https://community.qlik.com/t5/New-to-Qlik-Sense/Count-distinct-but-SUCCESS-clients-Part-2/m-p/198570...