topic Re: Date fields in QlikView

Date fields

surajap123 — Wed, 25 Jun 2014 12:04:37 GMT

Hi All,

Could anyone help me with creation of date fields(Year,Month, Day) to my autogenerate table below, so that i can use as list boxes in front end of my app-

LOAD

WeekStart(date(Today() - RecNo()*7)) as Weekstart,

WeekEnd(date(Today() - RecNo()*7)) as Weekend

autogenerate 100;

Re: Date fields

Gysbert_Wassenaar — Wed, 25 Jun 2014 12:07:22 GMT

Use a preceding load:

LOAD *,

Year(Weekstart) as Year,

Month(Weekstart) as Month,

Week(Weekstart) as Week,

Day(Weekstart) as DayWeekstart,

Day(Weekend) as DayWeekend;

LOAD

WeekStart(date(Today() - RecNo()*7)) as Weekstart,

WeekEnd(date(Today() - RecNo()*7)) as Weekend

autogenerate 100;

Re: Date fields

surajap123 — Wed, 25 Jun 2014 12:22:00 GMT

Thanks you so much Gysbert !!