topic Re: How can i show in a Pivot table the same count in the corresponding field in QlikView

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

olramirez — Sat, 16 Nov 2024 18:12:21 GMT

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

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

zhadrakas — Fri, 21 Aug 2020 05:47:12 GMT

maybe try this expression:

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

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

olramirez — Fri, 21 Aug 2020 15:31:32 GMT

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

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

Brett_Bleess — Thu, 03 Sep 2020 14:48:45 GMT

@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