Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

count of rows in pivot table chart title


I have a pivot table and it has 15 conditionally enabled dimensions. Those dimensions can be enabled through a user selections so he can decide which dimensions he wants to see in the pivot table

Now I have a problem. I want to display the count of rows in the pivot table title. Can someone please tell me how do I get the pivot table row count in the chart title. If the dimensions were fixed, I could have used count(distinct dimensions1&dimension2&dimension3) but here I dont know how many dimensions the user selects

I will appreciate your help


Tags (2)
1 Reply
Valued Contributor

Re: count of rows in pivot table chart title


You can calculate which dimensions were selected by user.

For example, add variable vTest:

=Concat( Name_Your_Field_For_User_Select,'&')

And then

=count(distinct $(vTest))