topic Re: Using ColorMix Function in QlikView

Using ColorMix Function

ZoeM — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Using ColorMix Function

vamsee — Wed, 07 Nov 2018 15:24:46 GMT

Refer

Using ColorMix In Qlikview

Re: Using ColorMix Function

ZoeM — Thu, 08 Nov 2018 12:11:29 GMT

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

Re: Using ColorMix Function

martinpohl — Thu, 08 Nov 2018 13:03:36 GMT

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

Regards

Re: Using ColorMix Function

ZoeM — Thu, 08 Nov 2018 14:51:44 GMT

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)

Re: Using ColorMix Function

martinpohl — Thu, 08 Nov 2018 15:24:52 GMT

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?

Re: Using ColorMix Function

ZoeM — Thu, 08 Nov 2018 19:26:04 GMT

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