topic Color code expression in QlikView

Color code expression

Wed, 19 Apr 2017 07:21:46 GMT

Hi all ,

does the following code is correct? not working actually

if(Status='Sanctioned But Not Disbursed',$(Blue),

if((Today-Date1)>=0 and (Today-Date1)<=1,$(Pink),

if((Today-Date1)>=2 and (Today-Date1)<=3,$(Yellow),

if((Today-Date1)>=4 and (Today-Date1)<=5,$(Green),

if((Today-Date1)>=6 and (Today-Date1)<=14,$(Blue),

if((Today-Date1)>=15 and (Today-Date1)<=30,$(Blue),

if((Today-Date1)>=31,$(Beige))))))))

Any Advice

Regards

Charlie

Re: Color code expression

parul_mehta — Wed, 19 Apr 2017 07:36:23 GMT

Try this, and give the code in the dimension text color

if(pause_description='Pause 15min',Blue(),if(pause_description='Pause 10min',Red(),Green()))

The conditions will need to be given in proper set expressions.

Re: Color code expression

parul_mehta — Wed, 19 Apr 2017 07:57:36 GMT

Try this in edit expression

=if([Order Date1]>=0 and [Order Date1]<=1,LightBlue(),if([Order Date1]>=2 and [Order Date1]<=3,Yellow(),if([Order Date1]>=4 and [Order Date1]<=5,LightCyan(),LightGray())))

LOAD sales,
[Order Date],
Date#(today()) as systemdate,
date#(today() - [Order Date]) as [Order Date1]
FROM
[..\Desktop\Book1_try.xlsx]
(ooxml, embedded labels, table is Sheet1);