topic Colour scale using multiple if functions in App Development

Colour scale using multiple if functions

Wed, 30 Mar 2016 07:06:41 GMT

Hi all,

I want to at a colour scale from light to dark for the highest value to the lowest value on my pivot table

Is it possible to use a multiple if function or can i use an other function for this

if(hrank(sum([Totaal omzet 2016]))=1,green()),if(hrank(sum([Totaal omzet 2016]))=2,ligt green()) etc…

Re: Colour scale using multiple if functions

Gysbert_Wassenaar — Wed, 30 Mar 2016 07:28:07 GMT

There are two function called ColorMix1 and ColorMix2. You can use the ColorMix Wizard to create an expression that uses one of these. You can find that Wizard in the menu of the expression editor.

Re: Colour scale using multiple if functions

Wed, 30 Mar 2016 07:57:58 GMT

Hi Gysbert

This is not possible in the click sense app

Re: Colour scale using multiple if functions

Gysbert_Wassenaar — Wed, 30 Mar 2016 11:16:12 GMT

Right you are. But if you have qlikview available you could generate the expression in Qlikview and copy it over to the Qlik Sense app. The Colormix functions are available in Qlik Sense too.

But there's another option that is a lot simpler. You can set the Colors setting to Custom and choose By Measure and select one of the four gradient options.

Re: Colour scale using multiple if functions

brunobertels — Wed, 30 Mar 2016 11:46:39 GMT

Hi Bob

In qlik Sense 2.2 you can use the colormixx function

See my post here with qvf example :

https://community.qlik.com/docs/DOC-16046

the file attached gives examples of how to use variable color to change all the colors of charts and table

ColorMix1( rank(total [your measure expression here])/noofrows(TOTAL) , rgb(15,97,119), rgb(36,242,197))

Regards

Bruno