topic Unique count from three different Fields in QlikView

Unique count from three different Fields

rolandies — Sat, 16 Nov 2024 01:53:20 GMT

Dear all,

I need to have the distinct count of three different field (let's say field A, B and C) in one expression.

I know the distinct count of two fields (A and B) in one expression is the following:
=Count(Distinct A) + Count({<B -= p(A) >}Distinct B)

I tried the following for the three field counter:
Count(Distinct A) + count({<B-= p(A)>}distinct B) + count({<C-= p(A)>}distinct C)

Unfortunately, it doesn't work.

Could you help me out? Thanks in advance!

Re: Unique count from three different Fields

sunny_talwar — Thu, 21 Nov 2019 14:50:37 GMT

May be this

=Count(DISTINCT A) + Count({<B -= p(A) >}DISTINCT B) + Count({<C-= p(A)+p(B)>} DISTINCT C)

Re: Unique count from three different Fields

Brett_Bleess — Thu, 05 Dec 2019 15:20:56 GMT

Roland, did Sunny's post help you get what you needed? If so, please be sure to return to the thread and use the Accept as Solution button on his post to give him credit for the assistance and to let other Community Members know this worked for you. If you still need further help, please leave an update.

Regards,
Brett