Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
olramirez
Contributor III
Contributor III

How can i show in a Pivot table the same count in the corresponding field

Hello,

please help me with this case:

I have a Pivot Table that has the Sala field which is an aggregation with count. It is an aggregation  with a field out of the table: sum(aggr(distinct count (distinct IdSala),%ID_CL))

I need the table show the same value count in each one of the Cost Center fields, for example: 

Hosp2_Ceco should show 4 in each field Hosp2_Ceco.

Hosp1_Ceco should show 3 in each field Hosp1_Ceco.

I think this is easy but i haven't been able to make it.

Thanks

 

 

 

 

3 Replies
zhadrakas
Specialist II
Specialist II

maybe try this expression:

sum(aggr(count (distinct IdSala),ClaseActivo, CentroCosto))
olramirez
Contributor III
Contributor III
Author

Thanks Zhadrakas, but i need the aggregation with the %ID_CL

 

 

Brett_Bleess
Former Employee
Former Employee

@zhadrakas  We have been having some notification issues, so I suspect you did not see the update to the thread on this post, so I just wanted to let you know.  

I am guessing you may need Set Analysis in the end on this one, not sure though, but here are a couple of links that may be helpful along those lines:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Apologies I do not have something better.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.