Qlik Community

App Development

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

cancel
Showing results for 
Search instead for 
Did you mean: 
shayraber
Creator
Creator

Grouped Bar Chart Conditional Coloring

Hi,

I'm trying to create a grouped bar chart per Business Unit.

The chart contains 2 measures:

1. actual sales vs budget this year

2. actual sales vs budget year ago

the is to color the measures by different rule. for example consider the following:

The first measure will be colored according to defined coloring (<80% in Red, 80%-100% in Yellow, 100%-120% in Green, over 120% in Light Blue).

The second measure will be colored constantly in Dark Blue.

see attached illustration.

if not possible - does someone has an idea of similar way to present the same which is possible?

 

Thanks a lot!

2 Replies
NitinK7
Specialist
Specialist

if you don't mind then could you attach here you sample qvf file with dummy data

shayraber
Creator
Creator
Author

Hi,

I can't provide a sample app, I can create a sample data even though I don't see the point.

Is it possible to color grouped bar chart but separate the coloring by measures?

I tried also to provide coloring to the measures as a maser items but unlike coloring a table value, in bar chart it seems impossible. also coloring master measure where the measure indicates a percentage and the value in necessarily between 0% and 100%