topic Re: Presentation agregation in QlikView

Presentation agregation

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

Hi community,

Is there any way to show in the total (in a straight table) the list of selected values of 1 or more dimension.

I explain:

My dimensions are: region, factory, product, sub-product.

My mesures are: quantity produced, quantity transferred, quantity bought, quantity sold, quantity received.

Right now I am using "totals on the last line" in the presentation tab.

I want to display the total depending on factory, region and product selected by the user. Lets say :

Total : {Region} {Factory(ies)} {Product}

Is it possible to achieve that?

Thank you,

Abdallah

Re: Presentation agregation

Anil_Babu_Samineni — Fri, 26 Oct 2018 09:38:16 GMT

Enable same feature for all dimensions like "Show Partial Sum"

Re: Presentation agregation

atoz1158 — Fri, 26 Oct 2018 09:42:36 GMT

Show Partial Sum is NOT available on Straight Tables only on Pivot Tables

Re: Presentation agregation

niclaz79 — Fri, 26 Oct 2018 09:51:31 GMT

Hi,

You should be able to use:

Sum(TOTAL <Region, Factory, Product> [Quantity Produced])

as a separate expression. It will show on all lines though which is unfortunate.

A more 'good looking' solution is to use Pivot Table instead of Straight Table and Partial Sum in Presentation tab.

Re: Presentation agregation

sunny_talwar — Fri, 26 Oct 2018 11:54:17 GMT

Would you be able to elaborate on this with an example as to what you have and what you are trying to get to?

Re: Presentation agregation

vinod22kv — Fri, 26 Oct 2018 14:02:58 GMT

Hi,

Yes, we can do that. please find the below link you can slove it.

https://www.youtube.com/watch?v=5eMV5NQY-5g

Regards,

Vinod.

Re: Presentation agregation

vinod22kv — Fri, 26 Oct 2018 14:06:16 GMT

Hi Sunny,

I am a big fan of you.

He is asking about the sub totels in a table.

Regards,

Vinod.

Re: Presentation agregation

absekrafi — Fri, 26 Oct 2018 14:58:19 GMT

Hi Sunny,

I am using a straight table. I have 3 dimensions and 10 mesures.

I am able to add a total line, as sum of the rows, in the bottom of the table. The label of this line I defined it as Total.

What I would like to know is:

1. am I able to add sub-totals,

2. am I able to add the value selected in my dimension (factory name) for example : Sub-Total {Paris, London} {sub-total value}

Thank you