# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Contributor

## Hard, different bar chart

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.

Tags (2)
1 Solution

Accepted Solutions
Not applicable

## Re: Hard, different bar chart

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

MC

5 Replies
Not applicable

## Re: Hard, different bar chart

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

MC

Contributor

## Re: Hard, different bar chart

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

BR

Contributor

## Re: Hard, different bar chart

Hi again,

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

Not applicable

## Re: Hard, different bar chart

Hi,

in this sample the percentage.

Regards

MC

Contributor

## Re: Hard, different bar chart

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...