topic Re: Relative/Aggr Data in a Two Dimensions Bar Chart in QlikView

Relative/Aggr Data in a Two Dimensions Bar Chart

shayraber — Sun, 31 May 2015 08:42:13 GMT

Hi all,

i want to create a bar chart with two dimensions as follows: a Year-Month and a Products Group.

(i know that Mekko Chart does the work BUT i need a Stacked Bar Chart...)

i want to present the sum of sales per Prod-Group and Year-Month

BUT

i need that data in percentage and not in absolute values AND i need each bar to represent a 100% of that month's sales.

assuming i have two groups and two periods.

period 1: 100 units of group A and 50 units of group B

period 2: 100 units of group A and 50 units of group B

i need to have two stacked bars. each one with 33% for group B and 67% for group A.

instead,

i get two bars. each one 16% for group B and 33% for group A

any help?

IAMDV — Sun, 31 May 2015 09:18:00 GMT

Hi,

Please post whatever you've done so far. It's easy to work with your example.

Cheers,

www.QlikShare.com

antoniotiman — Sun, 31 May 2015 09:30:59 GMT

Hi Shay,

see attachment.

Regards,

Antonio

shayraber — Sun, 31 May 2015 10:13:32 GMT

thanks!