topic Re: Hard, different bar chart in QlikView

Hard, different bar chart

boryspower — Wed, 17 Oct 2012 14:38:13 GMT

Hi,

I wonder if it is possible to create other than normal (different) chart type...

I have a table:

ID	Date	Stop code	Time
1	x1	1	234
2	x1	3	24
3	x1	2	63
4	x1	4	126
5	x1	Production	46
6	x1	3	71
7	x1	4	3
8	x1	Production	95
9	x2	1	24
10	x2	1	673
11	x2	5	32

The ID and Date are not important for the example, but I have there Stop codes and Time of each stop that happened. I'd like to create a bar chart as showed on attached picture. Is it possible? I hope the picture is understandable, if not than please let me know.

Re: Hard, different bar chart

Wed, 17 Oct 2012 15:08:01 GMT

Yes, it's a waterfall chart!

You have two methods:

1) bar chart with dimension,

one expression,

Total option in dimension limits tab, and with this Bar offset expression:

if(Dimensionality()=0,0,rangesum(above(sum(Time),1,RowNo()))).

2)bar chart without dimension, with n expression and with classic bar offest for any column.

look at this sample

Regards

Re: Hard, different bar chart

boryspower — Wed, 17 Oct 2012 19:08:19 GMT

Great! This is it! Works almost perfect Almost because... is it possible to have the Total bar on the left side? Than it would be perfect totally

Re: Hard, different bar chart

boryspower — Thu, 18 Oct 2012 13:00:49 GMT

Hi again,

Also - how to show the chart in percent? I wasn't able to do it using Bar Offset...

Re: Hard, different bar chart

Thu, 18 Oct 2012 15:13:04 GMT

Hi,

in this sample the percentage.

Regards

Re: Hard, different bar chart

boryspower — Fri, 19 Oct 2012 07:13:40 GMT

Hi,

The problem is that normally there are only few stopcodes for a specific date - not all of them... That is why I want to do it with you first advice (with Dimension in chart), not to write all possible stop codes in expression...