Monochrome effect in Pie/Doughnut chart

[joydipp1988]

Dear all,

I was working on different charts to create a monochrome effect. I found this type of charts in the following website- Donut Chart

Please have a look. My question, is it possible to create monochrome effect in Pie/Doughnut chart ? If yes then how ?

I did some work on it. PFA. Same expression worked on Bar chart but not working in Pie chart. Any hep will be appreciated. Thanks in advance.

Regards,

Joy

[joydipp1988]

Hello all,

Anyone got time to work on it ? Please let me know.

Regards,

Joy

[MarcoWedel · Accepted solution]

Hi,

maybe one solution could be:

RGB(255,
   (1-(Aggr(Sum(#SalesQuantity),@Product_CategoryName) / Max(TOTAL Aggr(Sum(#SalesQuantity),@Product_CategoryName)))) * 128 +127,
   (1-(Aggr(Sum(#SalesQuantity),@Product_CategoryName) / Max(TOTAL Aggr(Sum(#SalesQuantity),@Product_CategoryName)))) * 255)

see also Different shades of blue based on rank

hope this helps

regards

Marco

[vinieme12]

You may also want to Lookup Colormix! In Qlikview!

[joydipp1988]

Hi @Marco,

This is the solution I was looking for. Thanks for the solution. Its neat and clean and easy to understand. Thanks again.

Regards,

Joy

[MarcoWedel]

you're welcome

glad it worked for you.

regards

Marco

[joydipp1988]

Hello vinieme12‌

Can you provide the solution by using lookup Colormix in my app ? It will be helpful to understand the technique...

Regards,

Joy

[vinieme12]

Please see attached, and screenshot of steps, You can also find this on Qlikview Help!

Steps

Colormix will write the expression for you, just click OK and Apply.

Hope this helps

Cheers

V

[joydipp1988]

Hi vinieme12‌,

This is excellent solution. Thanks for the contribution.

Regards,

Joy