i have a question: is this possible to make the gradient on the base of colors (see screenshot) .
for instance: i have a project and progress-line: my project must be always done until 100 %, but today the level of my project is reached only 70 % from 100%. How can i show it on the base of colors, i mean, i want show 70 % (Grenn) from 100 % (Orange).
I know, there are the colormix-fun(), but i didnt achieved any results.
Does anybody have any idea?
Thanks a lot
Hi, you should look at Gauge chart. On the presentation tab set Max as 1 or 100%
Lower bound for segment1 is 0 and set Green color
Lower bound for segment2 is expression where you get current level of your project i.e. sum(CurrentLevel)
set color as Orange
first of all thanks a lot for your responce and time, i know this option with gauge, my issue is, i want to show colorgradient with a single bar-chart.
Do you have any idea?
so do like below
- create bar chart with stacked style
- first expression is sum(ReachedValue)
- second expression as 100% minus sum(ReachedValue)
- make color for each of expressions
I know stacked bar chart is available in Qlik Sense. if don't find in basic charts please look at extension branch
I have used such early
hope it helps
thanks a lot for this idea, i know this option, i thought whether is that possible with one colorexpression
no vseravno spasibo bolshoe