Qlik Community

Ask a Question

QlikView Documents

QlikView documentation and resources.

Announcements
Sept. 16, Qlik Product Portfolio Strategy and Roadmap for Data Integration 11 AM ET REGISTER NOW

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: