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

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


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.






3 Replies
Specialist II
Specialist II

maybe try this expression:

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

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



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:

Apologies I do not have something better.


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.