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.
you can try below expression in Actual bar color expression tab:-
IF([Planned Days]>=$([Actual Days]), green(), red())
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
bro in VIZLIB
you have this property
see the attach image each measure has condition color like qlikview
now VIZLIB is part of 2019 Feb edition
it is not possible with earlier versions , qlikview it is possible
Please remove planed bar chart color column and apply same expression only on Actual bar color expression tab.
try this expression in Actual bar color, color expression tab:
if(PlannedDays >= ActualDays, Green(), red())