topic Re: Dates comparision not filtering exactly in QlikView

Dates comparision not filtering exactly

Mon, 24 Nov 2014 12:15:39 GMT

Please help on Dates and Format which are complicating my days with out any error

Previous Thread:http://community.qlik.com/thread/142685

I need to display past 12 month of data from current date if suppose today is Nov we have Oct data like that created variables in Oct(10/31/2014) to (10/1/2013) data in between above should load and remaining data to be filtered not to load in App.

Accounting Period has 'YYYYMM' based on this created start and end date

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
let vstartdate=Date(MonthEnd(MONTHSTART(TODAY())-1),'MM/DD/YYYY');let venddate=Date(AddMonths(MONTHSTART(Today()),-13),'MM/DD/YYYY');

where Monthstart>=date('$(venddate)') and Monthend<=date('$(vstartdate)')<--- here it is not filtering exactliy

//Monthend(date( right(Date#( AccPrdOGIS,6), 'YYYYMM'))) <= Monthend( Today())//where Monthstart(date(Date#(right( AccPrdOGIS,6), 'YYYYMM'))) >=Monthstart( addmonths( Today(),-12))
//and
//Monthend(date( right(Date#( AccPrdOGIS,6), 'YYYYMM'))) <= Monthend( Today())//where Monthstart>=Date($(venddate),'MM/DD/YYYY')
//and Monthend<=Date($(vstartdate),'MM/DD/YYYY');
//
////where Monthstart>=date#($(venddate),'')
//and Monthstart<=$(vstartdate);

Re: Dates comparision not filtering exactly

Mon, 24 Nov 2014 20:00:48 GMT

Only Load data based on MonthStart and see the things once.

where Monthstart>=date('$(venddate)') and Monthstart<=date('$(vstartdate)')<---

or let me know how you are deriving MonthStart and MonthEnd columns.

Re: Dates comparision not filtering exactly

Tue, 25 Nov 2014 07:06:05 GMT

where Monthstart>=date('$(venddate)') and Monthend<=date('$(vstartdate)')

Thanx For solution missed date format now working fine.

Have you done this type of scenario before

Let say for each Financial Period a12 monhs of data in 1- QVD,

Having a.qvd,b.qvd,c.qvd<----2014

same for a.qvd,b.qvd,c.qvd<---2013

same for a.qvd,b.qvd,c.qvd<---2012

Now I need to compare or Load into App while Looping All years

Accounting Period:2014-November need to have 2014-Oct-31 to 2013-Oct-1

Above need to check 2014 & 2013 Folders any Idea and Sugesstions