topic Re: Problem with if condition and comparison dates in QlikView

Problem with if condition and comparison dates

geogou1973 — Sat, 11 Mar 2017 13:06:55 GMT

Hello.

I have the following formula in the background color of a field dimension

=if(COMPANY_CODE='01',argb(150,255,128,0),

IF(COMPANY_CODE=02 and CREATION_DATE<=$(UDATE),argb(150,128,255,128),

if(COMPANY_CODE='02',argb(255,255,255,255),

if(COMPANY_CODE='03',argb(150,0,101,179),

if(COMPANY_CODE='04',argb(150,100,177,255))))))

unfortunately the the comparison of the date CREATION_DATE<=$(UDATE) does not work.

Any help ?

Thank you in advance.

geogou1973 — Sat, 11 Mar 2017 13:26:19 GMT

i found that the CREATION_DATE<=$(UDATE) need ' like CREATION_DATE<='$(UDATE)'

vishsaggi — Sat, 11 Mar 2017 15:16:30 GMT

What is the date format of your CREATION_DATE field and in your variable $(UDATE).

DId you try giving single quotes around your variable as you mentioned like '$(UDATE)' ?