topic Re: Period date selecting!!! in QlikView

Period date selecting!!!

Tue, 10 Feb 2015 16:56:46 GMT

Hi All,

I have a date field for current year 2015 in data base , however i developed a master calendar for current year,

my master calender has 26 periods with 14 days in each period. now i want period for my date field that will come from data base.

[database date field having records only for today, now i want to know on which period my today's date will fall. ]

then i want to show this period start date and end date in a text object.

can any one help me on this.

Regards,

John

Re: Period date selecting!!!

Wed, 11 Feb 2015 12:07:27 GMT

Help !!

Re: Period date selecting!!!

Peter_Cammaert — Wed, 11 Feb 2015 12:36:21 GMT

The simplest method (but it may put some pressure on the Qlik UI) is to perform calculations on-the-fly. If your periods start on the 1st of january, then the period number is:

=1 + (DayStart(DatabaseDate) - YearStart(DatabaseDate))/14

If you call the previous expression vPeriodNo, then the start and end dates of that period become

=YearStart(DatabaseDate) + (vPeriodNo-1) * 14

=DayEnd(YearStart(DatabaseDate) + vPeriodNo*14 - 1)

[Edit] Minor correction to set Period End Date to a time value of 23:59:59

Re: Period date selecting!!!

Wed, 11 Feb 2015 13:20:38 GMT

Hi Peter Cammaert,

Can you Please provide me a sample for this explanation.

Thanks

John

Re: Period date selecting!!!

Peter_Cammaert — Wed, 11 Feb 2015 20:45:49 GMT

Here you go.