QlikView documentation and resources.
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.
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
Am I missing something?
On your Color by Expression
change your code from
If( ColorCode = 'DATA', Color( Ceil(Row/2)$(='+' & Min(ColorOffset)) ) , If( Row = 12 , Green(), White(0)) )
If( ColorCode = 'DATA', Color( Ceil(Row/2)$(='+' & Min(ColorOffset)) ) , If( Row = 12 , Green(), argb(0,0,0,0)) )
which is equal to transparent
Will check, thanks for your response.
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.
Hi - I changed the color expression, but I still see the grey chart.Am I missing anything ?