topic Re: Sorting Date in MMM-YYYY format in script in QlikView

Sorting Date in MMM-YYYY format in script

swati_rastogi27 — Thu, 15 Mar 2018 07:44:22 GMT

Hi All ,

Here is the list of Month Year values i have in my QVD:

Dec-2016

Jan-2017

Feb-2017

Mar-2017

Apr-2017

May-2017

Jun-2017

Jul-2017

Aug-2017

Sep-2017

Oct-2017

Nov-2017

Dec-2017

Jan-2018

For Incremental Load , i want to fetch data which is less than Jan-2018 and then concatenate recent data to it

I am using the statement :

Select <>

from <QVD>

where DATE_MONTH < date(MonthStart('Jan-2018'), 'MMM-YYYY')

so using this i don't get anything.

gerry_hdm — Thu, 15 Mar 2018 08:35:57 GMT

Hello

Format the var in 'mm.yyyy'

gruß Gerold

anagharao — Thu, 15 Mar 2018 08:51:28 GMT

Try:

Select <>

from <QVD>

where date(DATE_MONTH,'MMM-YYYY') < date(MonthStart('Jan-2018'), 'MMM-YYYY')

Note: if the DATE_MONTH is a predetermined format define that using DATE# function

tamilarasu — Thu, 15 Mar 2018 08:53:04 GMT

Hi Swati,

Select <>

From <QVD>

Where DATE_MONTH < Date(Date#('Jan-2018','MMM-YYYY'),'MMM-YYYY');