Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
msawyercke
Creator
Creator

Pie Chart Colors

Good Afternoon,

I use the following expression to try to use my own colors in a pie chart ("Custom Colors", "By Expression"):

If ([GR Status] = 'Not Growth Ready', LightRed(),

If ([GR Status] = 'Growth Ready', LightGreen(),

If ([GR Status] = 'Potentially Growth Ready', Yellow())))

This doesn't work in changing the colors of the 3 slices, all 3 pie slices are gray....

Why isn't this working properly?

Thanks much!

5 Replies
Digvijay_Singh

Not sure but it works as shown in attached image if there is any other complexity is not allowing it to work,

Capture.PNG

OmarBenSalem

it should be working; but It's better to facilitate things and do things as follow:

Assigning colors to master dimension values - Qlik Sense - YouTube

msawyercke
Creator
Creator
Author

Hi Digvijay,

I have the same screenshot as you and mine chart is not colored correctly.  As you can see the same formula does work in the table, however...just not in the pie chart...

Capture.JPG

msawyercke
Creator
Creator
Author

Omar,

My version of Qlik Sense does not offer the color selection options in Master Dimensions as shown in the video:

Capture.JPG

I wish it did offer it! 

Thank You for trying to help...

Anil_Babu_Samineni

Can you share QVF, Where it doesn't work for you

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful