Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

beck110979
Valued Contributor III

gradient within bar-chart or intervall

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

12 Replies
YoussefBelloum
Esteemed Contributor

Re: gradient within bar-chart or intervall

Hi,

Can you attach a QVW with some data ?

beck110979
Valued Contributor III

Re: gradient within bar-chart or intervall

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

maxsheva
Contributor

Re: gradient within bar-chart or intervall

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

beck110979
Valued Contributor III

Re: gradient within bar-chart or intervall

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
Valued Contributor

Re: gradient within bar-chart or intervall

Hi

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

beck110979
Valued Contributor III

Re: gradient within bar-chart or intervall

Hi Bruno thanks a lot for your responce,

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

Thanks a lot

maxsheva
Contributor

Re: gradient within bar-chart or intervall

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

beck110979
Valued Contributor III

Re: gradient within bar-chart or intervall

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
Valued Contributor

Re: gradient within bar-chart or intervall

Hi

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

Is this below what you are looking for :

Capture.PNG