Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Read about the latest Qlik Community enhancements on the Community News blog!
Showing results for 
Search instead for 
Did you mean: 

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 - 



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
Support (Former)
Support (Former)

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


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



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.