Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group

Qlik Sense Waterfall Chart with Bar Chart (without extension)

MVP
MVP

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

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

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
Contributor III
Contributor III

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: