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: 
Vasiliy_Beshentsev
Creator III
Creator III

How to make sub-headings?

Hello everyone!

How can i divide my measures by 2 big columns?

So i got this:

в33йцвау3в.png

And i want to sub-heading my measures over with red lines in 2 sub-columns like this:

32r23r.png

4 Replies
ansarikashif2017

You might get the grouping from the data model and drag both the Dimenion into the Column part of Pivot. QS will then group both of them and show the the grouped column with a + sign which you can click to see the underlying values (25,30,35....etc)

Screen1:

Screen1.PNG

Screen2:

Screen2.PNG

Vasiliy_Beshentsev
Creator III
Creator III
Author

I can't do like that because my measures self-maked in expressions.

Vasiliy_Beshentsev
Creator III
Creator III
Author

It's possible way only if i make measures in load data script.

ansarikashif2017

Are the columns in the pivot table dynamic i.e. can the value in the series 25 30 35...60 increase further or it will remain the same?

If they remain the same, probably in some way you can use the same expression which calculates the measure value to construct a dimension which retruns string such as "25", "30", "35"....."0","5","10"...etc