topic Re: Counting distinct Value based on two field in QlikView

Counting distinct Value based on two field

DipeshVadgama — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to count distinct value base on 2 Fields. Below is example,

Id's & Defect Code can be duplicate as per data, but I just need Unique count for ID & Defect Code.

like = Count(Distinct(ID) , Distinct(Defect Code))

Result = 5 ( Highlighted Yellow for example)

prat1507 — Thu, 27 Jul 2017 15:36:08 GMT

Maybe this

If([Defect Code]<>'-',count(distinct(ID)))

DipeshVadgama — Fri, 28 Jul 2017 12:50:20 GMT

Thanks Pratyush,

But is not working 😞

sunny_talwar — Fri, 28 Jul 2017 12:53:54 GMT

May be this

Count(DISTINCT {<ID = {"=Count([Defect Code]) > 0"}>} ID)

Count(DISTINCT {<[Defect Code] = {'*'}>} ID)

DipeshVadgama — Fri, 28 Jul 2017 13:22:18 GMT

Thanks Sunny,

Count(DISTINCT {<[Defect Code] = {'*'}>} ID)

This works perfect.

Appreciate if you can explain this formula to me. DISTINCT {<[Defect Code] = {'*'}>}

sunny_talwar — Fri, 28 Jul 2017 13:24:10 GMT

The expression is just distinct counting IDs where Defect Code is not null ({<[Defect Code] = {'*'}>})

DipeshVadgama — Fri, 28 Jul 2017 13:26:49 GMT

Great Thanks for you help.

sunny_talwar — Fri, 28 Jul 2017 13:28:13 GMT

No problem at all