Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

How to change the last year YTD bar to gray color now is red color ?

Hi All

My chart have 2 Bar , one is YTD sales another is last year YTD sales.

Now the sales bar is yellow color and the last year YTD bar is red color .

May i know how to change the sales bar color to Green and last year sales bar to gray color ?

Paul

4 Replies
paulyeo11
Valued Contributor II

Re: How to change the last year YTD bar to gray color now is red color ?

my QVF

rbartley
Contributor III

Re: How to change the last year YTD bar to gray color now is red color ?

Hi,

I would suggest you include a last year flag field in your load script so that this can be used in your colour expression.

paulyeo11
Valued Contributor II

Re: How to change the last year YTD bar to gray color now is red color ?

Hi Richard


Thank you very much for your sharing.

So do you mean it i must modify my load script in order to be able change my bar color ?

otherwise i may need to look into how to change the way i plot the chart with out using valuelist.

Paul

rbartley
Contributor III

Re: How to change the last year YTD bar to gray color now is red color ?

Yes, modify the load script and then change the Colours and legend property to something like if([latest_year_flag] =1,lightgray(),green()). 

ColourExpression.PNG

Community Browser