Need help with coloring a pie chart based on calculated dimension

[praveensp]

Hello Experts,

I am working on a dashboard , that has a pie chart created with a calculated dimension.

The formula used for calculated dimension is - 

=if(
if((DATE(DUE_ON_DOCK_DATE,'MM/DD/YYYY')<=date(vDate-CUMMULATIVE_LT,'MM/DD/YYYY')),QTY_DUE,0)+TOTAL_ONHAND_QTY>=aggr(nodistinct sum(EXT_QTY),COMPONENT),

'Sufficient','Insufficient')

This is a Status column that gives me the output of Sufficient and Insufficient values.

In the above formula, the vDate is a variable that will hold the date value entered by the user through a input box.

The expression here is - 

=count( {<PROCESS_CODE={'B'}>} distinct COMPONENT)

The objective is to create a pie chart that shows the count of components that are Sufficient and Insufficient.

I am facing error while applying color to the calculated dimension. If i use the formula used in the calculated dimension in the background color, it doesn't go into the "if" condition. Just moves out of the else and gives only red color for both the statuses.

Could someone help me out on this?

[Brett_Bleess]

Best I have to try to help you move forward is the following Design Blog post:

https://community.qlik.com/t5/Qlik-Design-Blog/Colors-in-charts/ba-p/1475280

Hopefully that may help somewhat.  If you want to search on your own, start on this link:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett