Background Color Expression for cyclic Group.

[#1]

Hi,

With cyclic group i am facing issue to get the correct color for the different bars even i mentioned proper Background color expression.

Does anybody have any idea how to specify the background color for different bars with cyclic Group.

Thanks

[#2]

Hi Miguel,

Enven not showing the correct Result.

[#3]

Hi Miguel,

Enven not showing the correct Result.

Thanks in Advance.

[#4]

Hi Mansi,

you have renamed the cyclic group. Try:

if(GetCurrentField(PriorVsRiskReq) = 'REQ_RISK', RiskColor, if(GetCurrentField(PriorVsRiskReq) = 'REQ_PRIORITY', PriorityColor))

Have Fun With QV

Alex:)

[#5]

Thnx Alex. It is great help.

[#6]

Hi Miguel,

Thank you so much for the g8 help.

I want to do same thing with Drill Down group.

For your consideration i am attaching the QVW for the Drill Down Group.

I am not sure this logic will work for Drill Down.

Please tell me if samething can be done for drill down.

Thnx in Advance.

[#7]

Hi Mansi,

It works too, just change the sentence with the following:

=if(GetCurrentField(PriorVsRiskDefect) = 'BG_STATUS',
StatusColor,
if(GetCurrentField(PriorVsRiskDefect) = 'BG_PRIORITY_DEFECT_SUMMARY',
PriorityDColor,
RiskDColor)
)

And don't forget the Enviornment issue in the BG_Status field.

Best regards.

[#8]

Thanks Miguel for your help.