Need help with coloring a pie chart based on calculated dimension

praveensp — Sat, 16 Nov 2024 19:35:01 GMT

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?

Re: Need help with coloring a pie chart based on calculated dimension

Brett_Bleess — Mon, 09 Dec 2019 22:04:40 GMT

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

topic Re: Need help with coloring a pie chart based on calculated dimension in QlikView

Need help with coloring a pie chart based on calculated dimension

Re: Need help with coloring a pie chart based on calculated dimension