topic Re: Modifying Dimensions in QlikView

Modifying Dimensions

qlikofba — Tue, 16 Oct 2018 20:17:03 GMT

Hi,

Is there any possible way to show my data as attached? The first chart is the current structure, the second chart is what I want it to look like. I want to take the totals of Commercial from each region and sum that at the bottom, then total consumer from each and sum, then total Government. I know this easily can be done by creating another straight table but was curious if there is another way to do this?

In a perfect world i would remove the whole region column from the bottom and display Central total where Total is, then Other total where total is etc.

Thanks,

Re: Modifying Dimensions

dplr-rn — Tue, 16 Oct 2018 20:19:34 GMT

check below link

hope it helps

Mini Bar Chart inside Straight Table and in List Box

Re: Modifying Dimensions

maddysalunke — Wed, 17 Oct 2018 09:54:40 GMT

Hi Anthony,

Try creating a Pivot table where Account types -Consumer ,Government , Commercial becomes columns .

You can then show Totals on columns as well as Row.

go to chart property--> presentation tab--> enable "Always fully expanded"

and "Show Partial Sums" check box then you will get the desired output.

Thanks,

Madhura