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: 
boryspower
Creator
Creator

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.

1 Solution

Accepted Solutions
Not applicable

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

View solution in original post

5 Replies
Not applicable

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
Creator
Creator
Author

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
Creator
Creator
Author

Hi again,

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

Not applicable

Hi,

in this sample the percentage.

Regards

MC

boryspower
Creator
Creator
Author

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