Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ferha_jafri
Partner - Creator III
Partner - Creator III

Use of Colormix function

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.

5 Replies
ferha_jafri
Partner - Creator III
Partner - Creator III
Author

Any body have an idea about colormix.

sibin_jacob
Creator III
Creator III

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



sunny_talwar

Did you try using the ColorMix Wizard...?

Capture.PNG

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

Capture.PNG

suhaskharat
Contributor III
Contributor III

Hi Ferha,

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

swapneel22
Contributor II
Contributor II

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