Conditional color issue by cyclic group dimension in bar chart

karthikeyan1504 — Mon, 10 Aug 2015 05:54:09 GMT

Hi all,

I am facing an issue in bar chart with conditional color based on the cyclic group dimension which has four dimension inside.

For example,

Every dimensions in the cyclic group has different values as shown below,

Values of Dimension 1 in cyclic group:

Shipping document tracking: '<5 Days', '5 to 7 Days', '>7 Days'

Values of Dimension 2 in cyclic group:

Lead time tracking: '<5 Days', '5 to 7 Days', '>7 Days'

Values of Dimension 3 in cyclic group:

Buyer Payment tracking: 'On Time', '5 to 7 Days', '>7 Days'

Values of Dimension 4 in cyclic group:

Supplier Payment tracking: 'On Time', '5 to 7 Days', '>7 Days'

Having above mentioned as scenario, I have used the below formula in expression background color,

if(([Supplier Payment Tracking]='On Time' or [Buyer Payment Tracking]='On Time' or [Shipment Document Tracking]='<5 Days' or [Lead Time Tracking]='<5 Days'), RGB(75,189,43)

,if(([Supplier Payment Tracking]='<7 Days' or [Buyer Payment Tracking]='<7 Days' or [Shipment Document Tracking]='5 to 7 Days' or [Lead Time Tracking]='5 to 7 Days'), RGB(254,187,48)

,if(([Supplier Payment Tracking]='>7 Days' or [Buyer Payment Tracking]='>7 Days' or [Shipment Document Tracking]='>7 Days' or [Lead Time Tracking]='>7 Days'), RGB(217,4,4))))

Now the issue is, I am not getting the desired color I want.

Could anyone please advise me on this?

Thanks & Regards,

Karthikeyan.

topic Conditional color issue by cyclic group dimension in bar chart in QlikView

Conditional color issue by cyclic group dimension in bar chart