topic Re: RGB color in expression in QlikView

RGB color in expression

yoganantha321 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a column name RGB codes as shown below. But i need to pass the RGB value to background for the expressions. The RGB values may differ it cannot be calculated.

Output received using expression Color (RGB codes)

RGB codes expression(color(RGB codes))

0,176,240 RGB(0,0,0)

255,255,255 RGB(0,0,0)

Expected output:

RGB codes expression(color(RGB codes))

0,176,240 RGB(0,176,240)

255,255,255 RGB(255,255,255)

Anybody help me in this!

Regards,

Yoganantha Prakash G P

Re: RGB color in expression

manoj217 — Mon, 15 Oct 2018 07:10:15 GMT

concatenate the string with the rgb codes you will get your expression

Re: RGB color in expression

manoj217 — Mon, 15 Oct 2018 07:22:15 GMT

your have a color codes field have a value like 255,255,255 now you want to convert like this right RGB(255,255,255)

backend you can concatenate with this below code

'RGB (' & RGB codes &')' as RGB codes New

Re: RGB color in expression

yoganantha321 — Mon, 15 Oct 2018 07:31:26 GMT

but when i use the COLOR(RGB CODES) it is showing different color not showing the color RGB(0,176,240)

Re: RGB color in expression

Frank_Hartmann — Mon, 15 Oct 2018 07:49:30 GMT

try like this:

RGB(subfield([RGB codes],',',1) ,subfield([RGB codes],',',2) ,subfield([RGB codes],',',3) ) as [RGB codes]

Re: RGB color in expression

Anil_Babu_Samineni — Mon, 15 Oct 2018 10:45:20 GMT

Are you taking this expression as Expression? Or BG Color. It should be Background color of your expression? Can you show image how this written? Should work, If that is for BG color / If you sure, Please share sample application which is not working?