Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
kahl_dre
Partner - Contributor II
Partner - Contributor II

Has anyone ever done an accumulation of bar graph that looks like the example?

The values shown are the actual values and the accumulated total is shown at the end.

Sample.jpg

6 Replies
swuehl
MVP
MVP

Search the forum for waterfall chart, e.g. like

Waterfall Chart for Bridging data

Basically, use the bar offset expression attribute to shift your bars vertically.

rustyfishbones
Master II
Master II

Whatt version of Qlikview are you using?

You can go to Dimension Limits and Tick Show Totals, this will show a bar for the total values

You can then use the bar offset function in the Expression Definition

like here

2013-10-10_1442.png

Something like this for the bar offset

2013-10-10_1444.png

IAMDV
Luminary Alumni
Luminary Alumni

Hi,

I've made a video tutorial long back. Please check the below link...

http://qlikshare.com/338

Cheers,

DV

Anonymous
Not applicable

I think that the bar offset expression should be like this, to make sure ther is no offset for total bar:

if(count (distinct <dimension field>)=1, rangesum(above(sum([Sales Qty]),1, Rowno())), 0)

Af for the numbers - check "show values on data points"

kahl_dre
Partner - Contributor II
Partner - Contributor II
Author

Thanks for the assistance everyone. I got it figured out.

I ticked "Show Total" and then I added the following to the bar offset property:

     If(rowno()=1 or Dimensionality()=0,0,rangesum (above(sum(amount),1,rowno()-1)))

And this is the result (I still got to make it a bit prettier, but the basic design is what I need)

     QV Sample.jpg

kahl_dre
Partner - Contributor II
Partner - Contributor II
Author

So the customer has now decided that they do want the percentages that show in the background. The 78% \ 22% shown in the different colors.

Is it possible to do, or to even add a line that shows what makes up 80% of the total and what makes up 20% of the total?