Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
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

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

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

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

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

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

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