topic Re: Pivot Table row totals issue in QlikView

Pivot Table row totals issue

Anonymous — Tue, 01 Mar 2016 22:12:23 GMT

Hello experts, hope you can help me with this annoying problem I have been trying to solve this entire day.

I have a simple Pivot chart. Several dimensions in rows, one dimension for columns. I have 4 Expressions. I created row totals by selecting the dimension that goes across the top, and chose partial sums. All works ok, with one exception: I need to avoid totaling one of the expressions. In other words, I only want to see "Total" sums for three of the expressions (measures if you will), but one expression I want totally ignored as far as Total is concerned.

Is that possible in Qlikview?

Thank you very much!

Igor.

Re: Pivot Table row totals issue

sunny_talwar — Tue, 01 Mar 2016 22:37:10 GMT

You can use SecondaryDimensionality() to handle this situation. First I would add a new expression SecondaryDimensionality() just to check what number do you get for the total cell. Once you know the number (assuming its 1), you would do something like this:

=If(SecondaryDimensionality() = 1, '', YourExpression)

Find here to find more on this topic:

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

How to use - Dimensionality()

Re: Pivot Table row totals issue

jagan — Wed, 02 Mar 2016 02:34:08 GMT

HI,

Try

If(Rowno() = 0, '-', YourExpression)

Regards,

jagan.

Re: Pivot Table row totals issue

Anonymous — Wed, 02 Mar 2016 15:49:14 GMT

Thank you very much for the idea. I played with it, and best I could achieve was a blank total column, which is still there. Hard to believe that Qlikview gives no control over the Partial totals calculations.

Re: Pivot Table row totals issue

jagan — Thu, 03 Mar 2016 00:36:24 GMT

You can control the Partial totals by using

If(Rowno() = 0, '-', YourExpression)

If(Dimensionality() > 0, YourExpression, '-')

If(SecondaryDimensionality() > 0, YourExpression, '-')

Check this links for more details

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

How to use - Dimensionality()