COUNT DISTINCT on some fields

[Anonymous]

Hi,

I need some help with an expression on Qlik Sense.

I have the data table below

DR_GID	Error ID	KPI_DESC
31234	15	Data Accuracy
31238	14	Data Accuracy
31269	12	Data Accuracy
31300	15	Data Accuracy
31300	12	Data Accuracy
31300	12	Data Accuracy
31000	5	Data Completeness

I would like to count all the DR_GID with KPI_Desc= "Data Accuracy" but with unique Error ID

For example:  for DR_GID=31300 the result would to be 2

I don't know how to write the set analysis correctly

I hope someone can help me with this.

Thanks for your help.

Mor

[petter]

Count( DISTINCT [<KPI_DESC={'Data Accuracy'}>} [Error ID] ) could be what you are looking for as you can see in this table:

[Anonymous]

‌Hi again,

I want to present the results by other fields.

For example I want to count the number of DR_GID but present it by country, count the set analysis above and present the results by country.

Thanks

MOr

[sunny_talwar]

May be like this

Sum(Aggr(Count(DISTINCT {<KPI_DESC = {'Data Accuracy'}>} [Error ID]), DR_GID, Country))

[Anonymous]

Thanks a lot Sunny it WORKS!!!!!!!

[sunny_talwar]

Super

[pradosh_thakur]

Please Mark correct and helpful answers and close the thread so that  it can help others in future.