Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

pivot table partial sum label based on parent hierarchy

Hi,

I have 2 dimensions in pivot table:

marketname and division which comes under marketname.

1 expression which is sum of employee flag.

market name has 2 values : northeast and southeast.

in total of marketname column; i labelled as total premier.this is fine. But under total of division names column; it is showing total but i want marketname under which the division comes have to be displayed.

How to do it?

Pls find qvw attached.

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

That's not possible. Perhaps you can use a custom dimension like explained in this discussion: Custom Labels in Pivot Table


talk is cheap, supply exceeds demand