gradient within bar-chart or intervall

[beck_bakytbek]

Hi Folks,

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

Beck

[YoussefBelloum]

Hi,

Can you attach a QVW with some data ?

[beck_bakytbek]

Hi Youssef, unfortunately i dont any data, it was my question on the base of example

[maxsheva]

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

[beck_bakytbek]

Hi Max,

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?

Spasibo bolshoe

[brunobertels]

Hi

One way to trick this requierment is to plug a second mesure that's will represent the 100 % achieved project

[beck_bakytbek]

Hi Bruno thanks a lot for your responce,

is that possible in QS, do you have any examples ?

Thanks a lot

[maxsheva]

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

[beck_bakytbek]

Hi Max,

thanks a lot for this idea, i know this option, i thought whether is that possible with one colorexpression

no vseravno spasibo bolshoe

[brunobertels]

Hi

Yed it'is possible in Qlik Sense ( i use only QS )

Is this below what you are looking for :