Dimension Value Count against each of dimension value Qlikview

[gopal5879]

Hello folks, 

I need some help with set analysis question.

I have data sample as posted below . I am using  expression 
Aggr(NODISTINCT count( distinct pid ),tin,pid) to compute expression Provider count.

Now the business requirement changed., Have to show total number of providers as shown in field Provider count highlighted in yellow  for each of the tin against each pid

Can someone suggest me  how my set analysis expression should look like please?

[MayilVahanan · Accepted solution]

Hi @gopal5879 

Try like below

count(Total<tin> distinct pid )

[gopal5879 · Accepted solution]

Hello Mayil, 

It works, thanks a lot for your time. Appreciate your help 

[MayilVahanan · Accepted solution]

Hi @gopal5879 

If your requirement is satisfied, Can you pls close this thread by marking correct answer