Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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?