Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Accumulation and percentages in Bar chart

Howdy

             I have a graph that displays sales by dimension month-year. There are 5 expressions that calculate the percentage of sales by region and there is an expression for total cummulative sales. I would like to show the percentage of sales by region in the graph. The graph is a full-accumulation graph. The problem is when I use full-accumulation, the percentages for each month are summed resulting in values that are above 100%.

What I would like to show is the sales percentage by region for the cummulative total sales per month.

My expression for Region 1 looks like this :

=((sum({<IS_Region = {'Emergent Markets'}>} [Sales Value (USD)]))/1000000)/(sum([Sales Value (USD)])/1000000)

Region 2 :

=((sum({<IS_Region = {'Mature Markets'}>} [Sales Value (USD)]))/1000000)/(sum([Sales Value (USD)])/1000000)

My dimension is month year for the current year :

=if(Date>=YearStart(today()),MonthYear)

I have attached a snapshot of my graph. The different colors represent regions.