topic Re: Vertical Totals In Bar Chart in QlikView

Vertical Totals In Bar Chart

stevietm — Thu, 31 May 2012 11:53:59 GMT

Hi All

Please look at the picture.

I have a hard time to explain what i want , but maybe there is someone who understands and can help me.

Kind Regards

Stevie

Re: Vertical Totals In Bar Chart

swuehl — Thu, 31 May 2012 12:59:25 GMT

Stevie,

I assume that you know how to create the stacked bar chart, so it's all about the percentage calculation, right?

I wouldn't use the relative object for that, instead use as expression

=sum(Value) / sum(total Value)

if you want to see the share across all products and months (product add up to 100% in the year), or

=sum(Value) / sum(total<Month> Value)

if you want to see the share across all products, but related to the single month (products add up to 100% in each month)

Vertical Totals In Bar Chart

stevietm — Thu, 31 May 2012 13:17:39 GMT

Hi Stefan

Thanks for the help it worked.

Kind Regards

Stevie

Re: Vertical Totals In Bar Chart

swuehl — Thu, 31 May 2012 15:32:03 GMT

You're welcome.

If your question(s) are answered, please set the status of your threads appropriately and mark helpful and/or correct answers. This helps others to find relevant pieces of information more easily.

Regards,

Stefan