topic Re: Its tricky date reqiurment in QlikView

Its tricky date reqiurment

sunilkumarqv — Tue, 18 Feb 2014 11:06:11 GMT

set DateFormat='M/D/YYYY';

Let vStart = Date('4/30/2010') ;

Let vEnd = Date('1/31/2014');

MonthCal:

Load Date(Date-1) as Date ,RowNo() AS DateID;

Load Date('$(vStart)' + RecNo() ) as Date autogenerate '$(vEnd)' - '$(vStart)';

from above script i have created a dynamic dates and using RowNo() as DateID defined id for dates ,So here I want monthEnd dates that is also fine I created MonthEnd(Date ) it list out only MonthEnd Dates .I Want That Month End Date Ids to be Created Can any help me out .

Re: Its tricky date reqiurment

Gysbert_Wassenaar — Tue, 18 Feb 2014 11:25:55 GMT

MonthCal:

Load

Date(Date-1) as Date ,RowNo() AS DateID ,

Autonumber(monthend(Date-1)) as MonthEndID;

Load Date('$(vStart)' + RecNo() ) as Date autogenerate '$(vEnd)' - '$(vStart)';

Re: Its tricky date reqiurment

sunilkumarqv — Tue, 18 Feb 2014 11:31:16 GMT

No Syntax error Autonumber(monthend(Date-1)) as MonthEndID;

Re: Its tricky date reqiurment

Tue, 18 Feb 2014 11:52:19 GMT

The answer by Gysbert Wassenaar is correct

Add just a comma (,) after DateID (surely due to a bad copy/paste)

Fabrice

Re: Its tricky date reqiurment

Tue, 18 Feb 2014 12:07:43 GMT

Hi,

ADD comma ',' instead of semicolun ';' next to MonthEndID.

Re: Its tricky date reqiurment

sunilkumarqv — Tue, 18 Feb 2014 12:12:26 GMT

thanks a lot Gysbert its working but still i need to do some work fo finish it.

In chart i taken MonthEnd(Date) as Dimension so if i select a year 2011 its shows only that value .i want to be show previous year as well up to April 2010 in same way all years its possible or any other valuable solutions Please share these as soon as possible.