Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sgg_gaikwad
New Contributor II

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

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

3 Replies
sergey_maka8
Valued Contributor

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

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

sgg_gaikwad
New Contributor II

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

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

sergey_maka8
Valued Contributor

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

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.

Community Browser