topic Re: Date Condition in QlikView

Date Condition

upaliwije — Thu, 15 Oct 2015 06:22:45 GMT

Hi,

When I load data from my QVD file the condition highlighted in Red does not give the desired values. Pls advise me to rewrite the condition in a better and correct way

Load * from ................

(qvd)

WHERE MATCH (CLA_CODE,'MC','M4')

and Month(LOSS_DATE) &'-'& YEAR(LOSS_DATE)>='Oct-2012'

Re: Date Condition

gautik92 — Thu, 15 Oct 2015 06:25:21 GMT

Wat abt this?

Load * from ................

(qvd)

WHERE MATCH (CLA_CODE,'MC','M4')

and Month(LOSS_DATE)>='Oct' and Year(LOSS_DATE)>='2012'

Re: Date Condition

MK_QSL — Thu, 15 Oct 2015 06:27:58 GMT

Load * from ................

(qvd)

WHERE MATCH (CLA_CODE,'MC','M4')

and LOSS_DATE>='01/10/2012'

Re: Date Condition

jonathandienst — Thu, 15 Oct 2015 06:30:46 GMT

A date inequality using strings will not work - you will need to convert these to proper dates so that you have meaningful values to compare. But it looks like LOSS_DATE is already a date value:

WHERE ... And LOSS_DATE >= '2012/10/01'

This will work if LOSS_DATE is a date value and the date in italics is the default date format for you system/model.

If you want to compare to a string, then:

WHERE ... And LOSS_DATE >= Date#('Oct-2012', 'MMM-YYYY');

Re: Date Condition

ashfaq_haseeb — Thu, 15 Oct 2015 06:33:02 GMT

Hi,

Try like Below

Load * from ................

(qvd)

WHERE MATCH (CLA_CODE,'MC','M4')

and where MonthName (LOSS_DATE)= 'Oct 2012';