Discussion Board for collaboration on QlikView Management.
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?
Hi @gopal5879
Try like below
count(Total<tin> distinct pid )
Hello Mayil,
It works, thanks a lot for your time. Appreciate your help
Hi @gopal5879
If your requirement is satisfied, Can you pls close this thread by marking correct answer
Hi @gopal5879
Try like below
count(Total<tin> distinct pid )
Hello Mayil,
It works, thanks a lot for your time. Appreciate your help
Hi @gopal5879
If your requirement is satisfied, Can you pls close this thread by marking correct answer