topic Re: Date help in QlikView

Date help

bharatkishore — Tue, 19 Feb 2019 06:33:12 GMT

Hi All,

I have a date field in a table with 'YYYY-MM' format and i have years from 1950-01 to 2019-01.

Now i need to make all the years which are <=2011-01 to 2011-01.

I have give condition like this

if(date(Install_Date<='2011-01'),'2011-01',Install_Date) as Install_Date_Dummy, but in the list box i am getting as below:

But for 2011-01 i am getting left side in list box.. can you please tell me how to get all in one format.

Thanks,

Bharat

Re: Date help

tresB — Tue, 19 Feb 2019 07:03:10 GMT

It's not good practice to use text comparison here. Having said that, for a quick fix, you could try like:

if(date(Install_Date<='2011-01'),Date(Date#('2011-01', 'YYYY-MM'),'YYYY-MM'),Install_Date) as Install_Date_Dummy

Re: Date help

bharatkishore — Tue, 19 Feb 2019 07:11:12 GMT

I tried this as well and this also worked:

date#(if(date(Install_date<='2011-01'),'2011-01',Install_Date))