Qlik Community

Ask a Question

QlikView Documents

QlikView documentation and resources.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS

Qlik Sense Waterfall Chart with Bar Chart (without extension)

petter
Partner
Partner

Qlik Sense Waterfall Chart with Bar Chart (without extension)

A simple approach to get a waterfall chart with a bar chart. Using an offset segment that is set to white and a little bit logic in the load script to be able to read a straight-forward data table.

2015-04-12 #23.PNG

Attachments
Comments
sunny_talwar

petter-s‌ is this still working with the new version of Qlik Sense? I tried to open your file and all I see is this

Capture.PNG

Am I missing something?

0 Likes
Not applicable

On your Color by Expression

change your code from

If( ColorCode = 'DATA', Color( Ceil(Row/2)$(='+' & Min(ColorOffset)) ) , If( Row = 12 , Green(), White(0)) )

to this

If( ColorCode = 'DATA', Color( Ceil(Row/2)$(='+' & Min(ColorOffset)) ) , If( Row = 12 , Green(), argb(0,0,0,0)) )

which is equal to transparent

0 Likes
sunny_talwar

Will check, thanks for your response.

0 Likes
Not applicable

That is cool stuff!
is it possible to define a specific color for a measure directly?

Generating a new dimension just to tell the color is a bit anoying ... But then I am new to Qlik so I might have missed something.

0 Likes
BIDev
Creator
Creator

Hi - I changed the color expression, but I still see the grey chart.Am I missing anything ?

 

WF.PNG

Version history
Revision #:
1 of 1
Last update:
‎2015-04-12 03:48 PM
Updated by: