Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vanderson009
Contributor

Colour Issue On bar Graph

I have requirement as Forecast Vs Actual by Timeline.

For Timeline i have created Drill Down which contains Year,Quarter,Month,Week and my bar graph have two measures one is for Actual and other for Forecast. My requirement is when i drill from Year to Quarter (Similar for Quarter to Month to Week) then business want to change bar colour for both (Actual and Forecast). 

Thanks and Regards,

Villyee.

3 Replies
rangam_s
Contributor II

Re: Colour Issue On bar Graph

We can keep bar color based on dimension (only when we have single measure), but I don't know think there is an option to change the bar color based on drill down. However, you can use custom color as 'Multicolored' but the color of actual and forecast will remain same over the drill down.

sumanta12
Contributor II

Re: Colour Issue On bar Graph

Hi Villyee,

First you have to add both the measures(Actual & Forecast) in Master items(Measures) and as per requirement set measure color for both measures.

Then in Bar chart in color&legend section select Multicolor and use Measure as  library colors .

rajeshthakur292
Contributor II

Re: Colour Issue On bar Graph

Hi vanderson009,

Please see if the attached helps you.

Thanks,

RT

Community Browser