topic Solved in QlikView

Solved

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

Solved

Re: Pivot Table - Show only Subtotal for Expression (Without Rows)

sunny_talwar — Mon, 06 Jun 2016 20:32:24 GMT

Right now you have two expressions, to do what you are looking to do, you will need to use a single dimension (with pick(match...)) and then use a single expression. There are many examples of how this can be done, but if you want to see how this can be done for your case, you will have to provide a sample so that we can help you better

Re: Pivot Table - Show only Subtotal for Expression (Without Rows)

microwin88x — Mon, 06 Jun 2016 20:40:02 GMT

Would I get the same result if I use a single dimension and expression?

I've attached a screenshot with the expected result. Thank you!

Re: Pivot Table - Show only Subtotal for Expression (Without Rows)

sunny_talwar — Mon, 06 Jun 2016 20:45:08 GMT

You can get the same result, but the calculations will change a little

Re: Pivot Table - Show only Subtotal for Expression (Without Rows)

qliksus — Fri, 10 Jun 2016 08:24:51 GMT

You can add a dummy Calculated Dimension and name the Total lable in the presentation tab to % and check the Show partial sum for this dummy dimension

and in the Expression you can disable your Second Expression and use to Dimensionality to calculate the % value

Re: Pivot Table - Show only Subtotal for Expression (Without Rows)

sunny_talwar — Fri, 10 Jun 2016 10:20:19 GMT

I think we did manage to resolve this here: Pivot Table - Show only Subtotal for Expression (Without Rows)

microwin88x I suggest closing this thread by marking assumed answer and any helpful responses so that people like us, who are willing to help can focus on threads where they might be needed more.

Best,

Sunny