Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

0 Replies