Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
beck_bakytbek
Master
Master

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
Champion
Champion

Hi,

Can you attach a QVW with some data ?

beck_bakytbek
Master
Master
Author

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

maxsheva
Creator II
Creator II

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
Master
Master
Author

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
Master
Master

Hi

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

beck_bakytbek
Master
Master
Author

Hi Bruno thanks a lot for your responce,

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

Thanks a lot

maxsheva
Creator II
Creator II

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
Master
Master
Author

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
Master
Master

Hi

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

Is this below what you are looking for :

Capture.PNG