topic Re: color in a variable in QlikView

color in a variable

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

Hi all.

I want to colour background EXPR1 and wrote this in BACKGROUND COLOR:

if (Sum([EXPR1]) <= NUM, $(vColorBlack), $(vColorGreen))

where

vColorBlack=ARGB(100,0,0,0)

vColorGreen=ARGB(100,0,128,0)

The colors don't appear.

What should I write? I use varaibles because the colors can be changed very fastly.

thanks

Message was edited by: cristina lovati

Re: color in a variable

sunny_talwar — Tue, 19 Jul 2016 10:23:19 GMT

Is EXPR1 a field or is this expression label here? Also try the variables without the dollar sign expansion:

If(Sum([EXPR1]) <= NUM, vColorBlack, vColorGreen)

Re: color in a variable

miguelbraga — Tue, 19 Jul 2016 10:23:46 GMT

Hey there,

Have you put this expression as suggested in the following post?

Using RGB() and ARGB() to define colors

If not, try it. If yes, how and where did you wrote yiur variables?

Hope this helps,

Regards,

Re: color in a variable

Gysbert_Wassenaar — Tue, 19 Jul 2016 10:24:11 GMT

The syntax of the expression you posted looks correct. Can you post a small qlikview document that demonstrates the problem?

Re: color in a variable

amit_saini — Tue, 19 Jul 2016 10:30:42 GMT

Try:

First:

Later:

Thanks,

Re: color in a variable

nizamsha — Tue, 19 Jul 2016 10:39:37 GMT

if (Sum([EXPR1]) <=10, NUM, $(vColorBlack), $(vColorGreen))

if its not working check the file

Re: color in a variable

amit_saini — Tue, 19 Jul 2016 10:43:31 GMT

Sorry forgot to mention : U also need to use condition:

if (Sum([EXPR1]) <= NUM, $(vColorBlack), $(vColorGreen))

Thanks,AS

Re: color in a variable

vcanale — Tue, 19 Jul 2016 10:45:59 GMT

Hi,

It should work without dollar sign
if (Sum([EXPR1]) <= NUM, vColorBlack, vColorGreen)

Re: color in a variable

clovati — Tue, 19 Jul 2016 11:03:49 GMT

Just attached. The wish is in the background of the only expression (in comment). Thanks

Re: color in a variable

sunny_talwar — Tue, 19 Jul 2016 11:10:17 GMT

Seems to be working for me

The only issue was the one of the variables were using ARGC instead of ARGB

Re: color in a variable

Gysbert_Wassenaar — Tue, 19 Jul 2016 11:12:24 GMT

You have ARGC(100,0,0,0) as color vColoreNero instead of ARGB(100,0,0,0)

Re: color in a variable

amit_saini — Tue, 19 Jul 2016 11:16:53 GMT

Yes ,

Sunny and Gysbert...u guy's having eagle eyes

Thanks,

Re: color in a variable

amit_saini — Tue, 19 Jul 2016 12:16:29 GMT

Hi Clovati,

Sorry, but u should mark either Sunny or Gysbert reply as correct answer.

Just because of their suggestion's , I realized below variable issue:

Thanks,