Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Relative/Aggr Data in a Two Dimensions Bar Chart

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?

1 Solution

Accepted Solutions
Highlighted
Master III
Master III

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

Hi Shay,

see attachment.

Regards,

Antonio

View solution in original post

3 Replies
Highlighted
Luminary
Luminary

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

Hi,

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

Cheers,

DV

www.QlikShare.com

Highlighted
Master III
Master III

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

Hi Shay,

see attachment.

Regards,

Antonio

View solution in original post

Highlighted
Creator
Creator

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

thanks!