how to change colors in Mekko chart in chart object?

[#1]

hi Guys

I created Mekkochart in qlikview in that chart colors have not changed.I want to change that chart colors but I do not know how to change  the Mekko chart colors.please tell me out. I attached 2  snipping files below that are 1.Chart of colors changed snipping file 2.Chart of colors not changed snipping file.

Regards:

Madhu

[#2]

Like this?

[#3]

your  file is not opened in qlik view because  i am using  Qlik view personal edition please tell me answer  in another way Dariusz. thanks

[#4]

Use colormix wizard.

It will prepare expression like this:

ColorMix2 (if(sum(age)<3,-Sqrt(-(sum(age)-3)/(3-1)),Sqrt((sum(age)-3)/(6-3))), ARGB(255, 192, 192, 192), ARGB(255, 0, 0, 255), ARGB(255, 128, 128, 255))

Edit Expression/File/Colormix Wizard

[nizamsha]

PFA

[nizamsha]

PFA

[#7]

Dariusz your method worked but  the font color does not how to change the font color please tell me out.

[#8]

Yes, it is possoble.

Copy expression from "Background Color" into "Tex Color" (just under "Background Color").

Let me know if it helps!

regards

Darek