Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gopal5879
Creator
Creator

Dimension Value Count against each of dimension value Qlikview

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?

ScreenShot.jpg

 

 

3 Solutions

Accepted Solutions
MayilVahanan

Hi @gopal5879 

Try like below

count(Total<tin> distinct pid )

MayilVahanan_0-1612747507684.png

 

Thanks & Regards,
Mayil Vahanan R

View solution in original post

gopal5879
Creator
Creator
Author

Hello Mayil, 

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

View solution in original post

MayilVahanan

Hi @gopal5879 

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

Thanks & Regards,
Mayil Vahanan R

View solution in original post

3 Replies
MayilVahanan

Hi @gopal5879 

Try like below

count(Total<tin> distinct pid )

MayilVahanan_0-1612747507684.png

 

Thanks & Regards,
Mayil Vahanan R

View solution in original post

gopal5879
Creator
Creator
Author

Hello Mayil, 

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

View solution in original post

MayilVahanan

Hi @gopal5879 

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

Thanks & Regards,
Mayil Vahanan R

View solution in original post