Using ColorMix Function

[ZoeM]

Hi Community.

In the attached dashboard, I am trying have the cell background be two different colors and trying to see if the color mix function can help me. I currently have it as showing one color for two different items, but I would like the cell to have two colors (gradient).

Thanks for the help.

[vamsee]

Refer

Using ColorMix In Qlikview

[ZoeM]

Thanks for the suggestion Vamsee, but it did not produce the desired result.

[martinpohl]

Colormix is a function that works with values between 0 and 1 (or -1 to 1 when using colormix2)

Regards

[ZoeM]

I am not familiar on how I can create an expression to color the cell with both items as illustrated in the QVW (attached in original message)

[martinpohl]

Colormix1 only works with numeric values between 0 and 1 (row 1) and mixes two colors depending on the value.

You are working with text and which color should be shown as colormix?

[ZoeM]

Yes i am using text and I want a mix of yellow and green