topic Re: Use of Colormix function in QlikView

Use of Colormix function

ferha_jafri — Thu, 09 Aug 2018 09:14:19 GMT

Hello Experts,

I need your help as I never used Colormix function in qlikview . I am attaching an application and I want to show in a way that max value i.e 30 should in dark blue and the min value should get the lightest blue and the values in middle should be shades in between the darkest to the lightest.

Re: Use of Colormix function

ferha_jafri — Thu, 09 Aug 2018 10:39:29 GMT

Any body have an idea about colormix.

Re: Use of Colormix function

sibin_jacob — Thu, 09 Aug 2018 10:43:47 GMT

Use this formula in the background color of the expression.

expression tab , + symbol -> background color

ColorMix1( rank(total [your measure expression here] ) / NoOfRows(TOTAL) , $(vColorMixDark), $(vColorMixLight))

Create two variables

vColorMixDark

vColorMixLight

and assign RGB code for Dark and light color.

Details are avaiable in this link

Qlik Sense Color Range Theme Approach

Re: Use of Colormix function

sunny_talwar — Thu, 09 Aug 2018 10:51:35 GMT

Did you try using the ColorMix Wizard...?

Below image is just using Random Blue colors... but you can change them using the wizard....

Re: Use of Colormix function

suhaskharat — Thu, 09 Aug 2018 11:39:13 GMT

Hi Ferha,

You can check the below application, within expression background color of straight table. !

Re: Use of Colormix function

swapneel22 — Wed, 06 May 2020 12:49:26 GMT

Thanks @sibin_jacob for sharing the formula.

Its very easy to follow, and very easy to implement specially due to the variables used.

Kind Regards,

Swapneel