topic Re: How to Count Number of Column in Pivot table..? in QlikView

How to Count Number of Column in Pivot table..?

sgg_gaikwad — Tue, 22 Jul 2014 06:36:01 GMT

I want to create Variable for that & it should come without MIcro

Re: How to Count Number of Column in Pivot table..?

SergeyMak — Tue, 22 Jul 2014 06:43:21 GMT

Hi Swapnil,

Could you clarify why you need this number?

Because in pivot table you usually have dimension and the simple way is just Count(DISTINCT Your_Dimension).

If you have two Dimensions as column just multiply them Count(DISTINCT Your_First_Dimension)*Count(DISTINCT Your_Second_Dimension)

etc.

Regards,

Sergey

Re: How to Count Number of Column in Pivot table..?

sgg_gaikwad — Tue, 22 Jul 2014 06:47:58 GMT

Hi Sergey,

Thanks for your Response but the thing is i don't want to show that count in Pivot table..

i want it to show in Text box ( After any selection on dashboard it should count number of column in Pivot table)

Regards,

Swapnil

Re: How to Count Number of Column in Pivot table..?

SergeyMak — Tue, 22 Jul 2014 06:54:11 GMT

Swapnil Gaikwad wrote:

Hi Sergey,

Thanks for your Response but the thing is i don't want to show that count in Pivot table..

i want it to show in Text box ( After any selection on dashboard it should count number of column in Pivot table)

Regards,

Swapnil

That's why I asked you "Why you need this number" and my solution is good good for your purpose.

You, probably, know your dimensions in the pivot table. So just use them to count in text object.

If you share the app, I can calculate it for you.