Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
praveensp
New Contributor

Need help with coloring a pie chart based on calculated dimension

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?

 

1 Reply
Highlighted
Digital Support
Digital Support

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

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.