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

Announcements
Qlik Named a 7-Time Gartner® Magic Quadrant™ Leader: See the 2026 Report
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to only show the partial sum of expression in a pivot ignoring/hiding the dimension level sums

Hello,

I have a pivot table with 5 dimensions, I'm calculating an expression (here MGL) and all I wanted to show is its total ignoring the session level values.Is this possible in qlikview? I've inserted the screenshot below here. Many thanks in advance.

qv_query.png

Labels (1)
3 Replies
sunny_talwar

You can use Dimensionalilty to show an output wherever you desire. Check out these links

How to use - Dimensionality()

The second dimension... or how to use secondarydimensionality()

Not applicable
Author

Thanks for this article, but still doesn't solve of my problem. More context on how to use dimensionality will be great here.

sunny_talwar

A sample will be easier to help you out. Are you able to provide one?