Skip to main content

Member Articles

This forum is for user/member-created articles across the entire Qlik portfolio. Any member that is logged in can create and publish an article here. You must choose the appropriate label in order for the articles to be properly categorized.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!

Color Themes with ColorMix.qvf

cancel
Showing results for 
Search instead for 
Did you mean: 
brunobertels
Specialist III
Specialist III

Color Themes with ColorMix.qvf

Attachments

Hi all

 

I saw recently this post  about a very usefull and easy way to apply theme color in charts , map , gauge , crosstable and so on.

 

using colormix1 or colormix2 functions to set a range of colors depending of data , mesures, dimensions .. and using variable to define rgb colors in one time.

 

Thanks to ryy for this amazing exemple and sharing this App.

 

following this example I take avantage of this app and complete it with 2 others sheets.

 

First of them use variable button rather than imput text field to set color theme.

 

 

Second sheet added consists in a panel sheet to set up independantly for both dark color and light color the RGB values and see how colors are shading from one to the other :

 

I fixed 2 issues :

 

first : now by default in sheet with theme using variable button the app open by default on second theme 'Forest'

you can change the default theme by changing in variable panel the variable vcolorchoice figure 2 by 1 for aqua and 3 for purple  theme.

 

second : in last sheet : set color theme by slider : by default the app open with predifined value in the differents sliders, so that charts are not displayed in grey.

 

 

 

hope it could be usefull

 

Bruno

Tags (2)
Labels (1)
Comments
Greg_Williams
Employee
Employee

This is FANTASTIC! One of the most helpful app posted on QlikCommunity! Thanks. Great work!

-gw

tarek
Contributor
Contributor

Hi guys,

 

can we add a variable into the formular

ColorMix1( rank(total column(1))/noofrows(TOTAL) , rgb(15,97,119), rgb(36,242,197))

as

ColorMix1( rank(total v_color, rgb(15,97,119), rgb(36,242,197))?

 

Is there an option to do it like this? cause it does not work like I want it.

 

Kind regards

 

Tarek

 

Version history
Last update:
‎2022-08-04 06:22 AM
Updated by: