Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

boryspower
Contributor

Hard, different bar chart

Hi,

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

I have a table:

IDDateStop codeTime
1x11234
2x1324
3x1263
4x14126
5x1Production46
6x1371
7x143
8x1Production95
9x2124
10x21673
11x2532

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

boryspower
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

boryspower
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

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

Community Browser