Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
praveensp
Contributor
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?

 

Labels (1)
1 Reply
Brett_Bleess
Support (Former)
Support (Former)

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 do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.