I want to achieve the below visualization in qlik sense:
In this area chart there y axis will start from 0 only but the reference line is 3 and we have to represent if the point is above 3 than area between that point and 3 should be blue and if its less than 3 than it should be red .
Any suggestion which extension I cna use as tried with line chart but not able to achieve .
LOAD * Inline
Add a Line Chart to your sheet, using the Xvalue and Yvalue for the dimension and measure.
In the Chart > Appearance > Presentation, select Area.
In Appearance > Colors and Legend, select 'Custom' and 'By measure'.
Click the fx and input
=If( YValue > 0, blue(), red() )
It could has been a good idea, but it's working only if reference point is 0.
Question asked of varying area color referring on 3.
I add that I'd like that colours of area could change depending on the value of another expression.
Is there some hope of achieve the goal with a simple line graph?
I find out D3 Visualization Library extension in Qlik Branch:
and using Difference Chart I was able to create my chart.
Unfortunatly, I cannot change x-Axis (no scroll bar) and this is very limiting for long historical series of data.
Anyone has some other suggestion?
In this case, color will change at walue 3, but area will start from 0 value.
Furthermore, colors in expression don't overwrite default colors.
This is what I managed to get.