topic Hexadecimal Colors in QlikView

Hexadecimal Colors

Mon, 06 Feb 2012 15:37:20 GMT

hello all,

i have color in hexadecimal, is it possible to present the color?

many thanks,

avi

Hexadecimal Colors

ekech_infomotio — Mon, 06 Feb 2012 16:01:00 GMT

Hi avi,

last year this question was answered here http://community.qlik.com/message/17746#17746 with "no" in terms of direct hex-input. But you can always convert hexadecimal colors to RGB using different tools - online calculators (for example here: http://drpeterjones.com/colorcalc/) or self-written functions (for example here: http://community.qlik.com/message/33594#33594).

regards,

Edgar

Hexadecimal Colors

Mon, 06 Feb 2012 16:05:10 GMT

hi,

i have seen these posts allready, but they are not so helpfull !!!,

thanks any way.

Hexadecimal Colors

ekech_infomotio — Mon, 06 Feb 2012 16:20:28 GMT

may I ask why? you have to split up your hexadecimal color - first two digits for R, next two for G, last two for B. Calculation as implemented by Hector Munoz...

regards,

Edgar

Re: Hexadecimal Colors

Wed, 21 May 2014 22:27:57 GMT

hello avifarkash,

you can translate your hex colors to RGB and use syntax similar to the following:

If(Avg(%Field) = 1, RGB(142,158,130), If(Avg(%Field) = 2, RGB(202,204,182), ...etc.

or you could make variables using the RGB function and write it like this instead:

If(Avg(%Field) = 1, $(vGreenDk), If(Avg(%Field) = 2, $(vGreenLt), ...etc.

or you could put the HEX value straight into your expression as follows:

If(Avg(%Field) = 1, '#8E9E82', If(Avg(%Field) = 2, '#CACCB6', ...etc.

dollar sign expansion on the second method is not necessary, just best practices.

best,

Re: Hexadecimal Colors

ChristofSchwarz — Thu, 02 Oct 2014 13:35:30 GMT

simple formula: Num#('FF' & vHexColor,'(HEX)')

Use 6 hex digits in the place of vHexColor in the above formula.e.g AABBCC would be
Num#('FFAABBCC','(HEX)')

In QlikView the color representation is 4 bytes long, where the first byte is the transparency. If you dont want transparancy then - like in the above example - start with "FF" and then put the rest of your Hex Color Code. The result is a valid color in QlikView.

(Hi avifarkashwould be nice if you mark this thread as "answered" ...)

Re: Hexadecimal Colors

ThornOfCrowns — Thu, 02 Oct 2014 13:43:49 GMT

Nice answer. I hope that avifarkash breaks their multi-year silence to answer!

Re: Hexadecimal Colors

Thu, 09 Feb 2017 21:33:57 GMT

You can just use the hex number in color expression as it is.In color expression field enter hex number for example

'#F26E5B'

Re: Hexadecimal Colors

vinieme12 — Fri, 10 Feb 2017 06:41:59 GMT

Like this only

NOTE: HEXCODE should not contain '#' , if you have # then also add Purgechar()

=RGB(num(num#(left(HEXCODE,2),'(HEX)')) ,num(num#(mid(HEXCODE,3,2),'(HEX)')) ,num(num#(right(HEXCODE,2),'(HEX)')))

With Purgechar()

=RGB(num(num#(left(purgechar(HEXCODE,'#'),2),'(HEX)')) ,num(num#(mid(purgechar(HEXCODE,'#'),3,2),'(HEX)')) ,num(num#(right(purgechar(HEXCODE,'#'),2),'(HEX)')))

Re: Hexadecimal Colors

jonathandienst — Fri, 10 Feb 2017 07:27:41 GMT

Christof is correct. A colour value is simply a 32 bit (4-byte) number. Any expression which returns a 32 bit number can be used as a colour expression. RGB() and ARGB() also return a 32 bit number.

Splitting the hex number to feed into RGB() is messy and unnecessary. Use Christof's formula instead or a suitable adaptation to your requirements.

Re: Hexadecimal Colors

mosherterry — Wed, 30 May 2018 13:30:06 GMT

I'm using Qlik Sense Server April 2018 and I am able to just directly enter the Hex code as '#ffcf02' and it works.

Re: Hexadecimal Colors

jonathandienst — Mon, 04 Jun 2018 15:08:59 GMT

Yes, that works in most of the colour dialogs in Qlik Sense, but this is a Qlikview group.

Re: Hexadecimal Colors

andy_smith2005 — Fri, 27 Jul 2018 20:56:05 GMT

Unfortunately while this works the colours dont match for example try #59FFAA - which is green in hexadecimal but when converted is blue (RGB(89,159,170)

Re: Hexadecimal Colors

petter — Sat, 28 Jul 2018 09:51:12 GMT

Hex 59FFAA is composed of the three hex numbers 59, FF and AA. Clearly FF is 255 and not 159 as you have in the RGB(89,159,170).

So you will have to compare the colors #59FFAA with RGB(159,255,170) and see if they match....