topic Re: Date Picker in QlikView

Date Picker

Mon, 14 Oct 2013 06:24:17 GMT

Hi Guys,

Can someone tell me how to use and enable a date picker in your application in Qlikview.

Its Urgent..Pls Help.

Regards,

Rochelle

Re: Date Picker

Anonymous — Mon, 14 Oct 2013 07:01:58 GMT

First of all you need a calendar in your data:



TempCalendar:
LOAD
  $(vMinDate)+ITERNO()-1 AS NUM,
  DATE($(vMinDate)+ITERNO()-1,'D-M-YYYY') AS TempDate
AUTOGENERATE (1) WHILE
  $(vMinDate)+ITERNO()-1 <=  $(vMaxDate);


TRACE . . . Kalender - START LOAD Calendar;


Calendar:
LOAD *
  ,autonumber(Date)                       AS %Key
  ;
LOAD TempDate                               AS Date
  ,YEAR(TempDate)                         AS Year
  ,'Q' & Ceil(Month(TempDate)/3)          AS Quarter
  ,MONTH(TempDate)                        AS Month
  ,WEEK(TempDate)                         AS Week
  ,WEEKDAY(TempDate)                      AS WeekDay
  ,DAY(TempDate)                          AS Day
  ,DATE(MONTHSTART(TempDate), 'MMM-YYYY') AS MonthYear
  ,if (Week(TempDate)=1 and Month(TempDate)=12,Week(TempDate)&'-'&(Year(TempDate)+1), if (Week(TempDate)>=52 and Month(TempDate)=1,Week(TempDate)&'-'&(Year(TempDate)-1),Week(TempDate)&'-'&Year(TempDate)))  as WeekYear
RESIDENT
  TempCalendar
ORDER BY
  TempDate;




DROP TABLE TempCalendar;

After this you can put some multiple or single dropdown boxes on your screen containing these selections.
E.G. year / month / week / day ... or the complete date

You could also take a datetime picker on the Date field ...

rgrds Anita

Re: Date Picker

Mon, 14 Oct 2013 07:06:46 GMT

Hi,

what do you mean by a date picker?

Re: Date Picker

Anonymous — Mon, 14 Oct 2013 07:08:18 GMT

Datetime picker -- I mean the slider / calender object 😉

Re: Date Picker

Mon, 14 Oct 2013 07:27:55 GMT

How does one use a calendar object, if the user wants to select one and only value.Possibly by input via an input box?

Re: Date Picker

Anonymous — Mon, 14 Oct 2013 07:29:14 GMT

You can set the property's of the object that only 1 single selection can be made. (Mode = 1 single value)