Can we change the colors of bars in grouped bar chart based on condition in Qlik Sense?

[arpdharia]

I have a list of different projects with their planned duration days and actual duration days.

Now, I want to show the comparison of each project in the form of grouped chart where there will be two vertical grouped bars one showing planned duration and one showing actual duration of each project.

I created master items for two bars where I am able to assign two different colors for planned and actual duration days but I want to show that for actual duration bar, if planned duration days >= actual duration days then display bar as green color else red color.

Can any one help what is the best way to show such comparison in dash board ? This would help management get an idea about the delay of each task with respect to its planned duration.

[tush]

Hi,

      you can try below expression in Actual bar color expression tab:-

IF([Planned Days]>=$([Actual Days]), green(), red())

Thanks

Tushar

[Channa]

the problem i think hear it will change color of both bars..

it is possible in qlikview ..i think there is one extinction try branch 

[Channa]

bro in VIZLIB

you have this property

try extinction 

see the attach image each measure has condition color like qlikview

[arpdharia]

Hi Tushar, Thanks for the response but I had already tried this and it changes the colors of both bars.

[arpdharia]

Hi Channa, Thanks for your response but is it not possible without any extension?

[Channa]

Hi @arpdharia 

now VIZLIB is part of 2019 Feb edition

try it

it is not possible with earlier versions , qlikview it is possible 

[tush]

Hi,

    Please remove planed bar chart color column and apply same expression only on Actual bar color expression tab.

Thanks

Tushar

[tush]

Hi,

     try this expression in Actual bar color,  color expression tab:

if(PlannedDays >= ActualDays, Green(), red())

Thanks

Tushar

[arpdharia]

Hi , This is not feasible I am looking for a grouped bar chart solution. I don't have the option to do it only on one bar(actual in this case)