topic Re: Re: Compare dates inside if satement in QlikView

Compare dates inside if satement

anuradhaa — Tue, 24 Jun 2014 10:24:21 GMT

Hi,

I have data and i need to apply different values based on date.

I have the date format as '2014-06-07 17:02' i have used

Dual(Month(DATE_TIME) & '-' & Date(DATE_TIME, 'YY'), Num(Year(DATE_TIME)) & Num(Month(DATE_TIME), '00')) AS MonthYear,

to get monthyear.

then i need to apply one value till 'MAY-14' and another value after 'MAY-14'

i have used

=if((MonthYear < 'May-14' ), 'true' , 'yyy')

then for if Monthyear = 'JUNE-14 ' it display 'true' and may it show 'yyy'.

This is wrong. because 'JUNE-14' > May-14

please help me to solve this problem

Re: Compare dates inside if satement

Gysbert_Wassenaar — Tue, 24 Jun 2014 10:29:53 GMT

You're comparing strings. A word starting with a J is considered smaller than a word starting with an M. You need to compare numeric values instead. You can do that by creating dates from your strings.

=if((date#(MonthYear,'MMM-YY') < date#('May-14','MMM-YY'), 'true' , 'yyy')

Re: Re: Compare dates inside if satement

anuradhaa — Tue, 24 Jun 2014 11:12:39 GMT

It doesn't work , pls see attached qvw

Re: Re: Re: Compare dates inside if satement

ashfaq_haseeb — Tue, 24 Jun 2014 11:16:27 GMT

Hi,

look at the attached application.

Regards

ASHFAQ

Re: Compare dates inside if satement

MayilVahanan — Tue, 24 Jun 2014 11:25:21 GMT

Try like this

=if(Date#(MonthYear,'MMM-YY') > date#('May-14','MMM-YY'), 'true' , 'yyy')