Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

count of rows in pivot table chart title

Hi,

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

Shah

1 Reply
pokassov
Specialist
Specialist

Hi!

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))