topic Re: rgb in QlikView

rgb

Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends,

How to we use rgb() function at expression level could you give me the brief explanation ?

in my Chart i have dimension like Department_ID.

my Expression is Sum(salary).

I would like to segregate salary like 2000 to 3000 and 30001 to 40000 another colour one color how can achieve this ?

Re: rgb

Wed, 11 Jan 2017 03:20:46 GMT

Hi Siva,

Click on the + icon in your expression and click on back ground color . In its definition, enter your necessary condition.

Eg:

If([Q2]>[Q1], rgb(108,179,63),

If([Q2]=[Q1], yellow(),

If([Q2]<[Q1], rgb(255,110,110))))

Hope it helps!

Kiruthiga

Re: rgb

devarasu07 — Wed, 11 Jan 2017 03:22:47 GMT

Hi,

refer to the attached sample app

Try like this at background Color,

if(sum(Salary) > 2000 and sum(Salary) <= 3000 ,rgb(108,179,63),

if(sum(Salary) > 30001 and sum(Salary) < 40000 ,rgb(108,179,63),yellow()))

Tks

Deva

Re: rgb

varshavig12 — Wed, 11 Jan 2017 03:24:50 GMT

Example:

If you want to change the background color,

i.e properties --> expression --> Your exp --> Background color

and in background color definition:

if(sum(Salary)>=2000 and <=3000, rgb(100,0,0),

if(sum(Salary)>=3001 and <=4000, rgb(100,100,0)))

Re: rgb

amit_saini — Wed, 11 Jan 2017 04:46:00 GMT

Hi Siva,

You need to do something like below:

Thanks,

Re: rgb

ramasaisaksoft — Wed, 11 Jan 2017 06:29:09 GMT

Hi Siva,

instead of writing RGB() function in Straight table we have option

Properties of the S.table->Visual Cause Tab select the expression to which you want to show different colors->

sum(Sales)>100 Red

<100 Green color

like that u will get default 3 colors u can change these colors also as per your wish.

Re: rgb

Thu, 12 Jan 2017 10:32:56 GMT

Thnaks

Re: rgb

Thu, 12 Jan 2017 10:33:19 GMT

Thanks

Re: rgb

Thu, 12 Jan 2017 10:33:40 GMT

Hi Varha,

Thanks.

Re: rgb

varshavig12 — Thu, 12 Jan 2017 11:05:28 GMT

If you got the solution, Please mark that comment as correct and close the thread.

Regards,

varsha