topic Re: ColorMix1 with hex color? in QlikView

ColorMix1 with hex color?

mmarchese — Tue, 05 Dec 2017 20:38:24 GMT

Is it possible? Something like this:

ColorMix1($(some_variable), white(), '#4477aa')

I don't know what the correct syntax is, but the above does not work.

Re: ColorMix1 with hex color?

petter — Tue, 05 Dec 2017 21:25:14 GMT

You can do this:

ColorMix1( $(some_variable) , white() , Num#( '4477aa' , '(HEX)' ) )

Re: ColorMix1 with hex color?

mmarchese — Wed, 06 Dec 2017 17:17:30 GMT

That sort of works, but the result looks glitched out as shown in the screenshot below.

The left column's background color formula is:

ColorMix1(Expression3, white() , rgb(68, 119, 170))

The right's color formula is:

ColorMix1(Expression3, white() , Num#('4477aa', '(HEX)'))

Re: ColorMix1 with hex color?

Kaushik2020 — Mon, 06 Oct 2025 08:53:55 GMT

does this really work with a treemap ? i am using a treemap where i am using something like below for the Color by Expression property.

ColorMix1(Sum(ProjectsCount), white() , Num#('008FB8', '(HEX)'))

Re: ColorMix1 with hex color?

marcus_sommer — Tue, 07 Oct 2025 12:11:33 GMT

Not all objects support all features. Therefore apply fixed values within a dummy to test the functionality - something like: colormix1(0.5, white(), red())

If this is working make sure that the expression returns always a valid result, for example with something:

alt(rangemax(0, rangemin(1, MyExpression)), 0.5)

A single invalid result or NULL may result in a strange behaviour or that the entire logic is skipped.

Beside the above may the num#() beeing wrapped with a num(). Helpful may also to put the hex-code and/or the rgb() and/or the auto-color like lightblue() with a wrapping num() in a table - because all should be resolved to a number().