topic Re: Fortnight function in QlikView

Fortnight function

Sat, 01 Nov 2014 06:25:22 GMT

Is any fortnight function available like Week,Day etc.

Re: Fortnight function

Anonymous — Sat, 01 Nov 2014 06:42:04 GMT

No but you could try something like

round ( week ( today() ) / 2 )

Re: Fortnight function

anbu1984 — Sat, 01 Nov 2014 11:23:34 GMT

=Date( today()+14 ) --Fortnight date

=Week( today()+14 ) --Fortnight week

Re: Fortnight function

ashfaq_haseeb — Sat, 01 Nov 2014 12:10:29 GMT

Hi,

Check this.

Regards

ASHFAQ

Re: Fortnight function

MarcoWedel — Sat, 01 Nov 2014 13:13:19 GMT

Hi,

maybe one solution could be:

SET Fortnight = Ceil(Week($1)/2);
SET FortnightName = Dual(WeekYear($1)&'/'&Num(Ceil(Week($1)/2),'00'),MakeWeekDate(WeekYear($1),Ceil(Week($1)/2)*2-1));
SET Quarter = Dual('Q'&Ceil(Month($1)/3),Ceil(Month($1)/3));

tabCalendar:
LOAD *,
    Day(Date) as Day,
    WeekDay(Date) as WeekDay,
    Week(Date) as Week,
    WeekName(Date) as WeekName,
    $(Fortnight(Date)) as Fortnight,
    $(FortnightName(Date)) as FortnightName,
    Month(Date) as Month,
    MonthName(Date) as MonthName,
    $(Quarter(Date)) as Quarter,
    QuarterName(Date) as QuarterName,
    Year(Date) as Year,
    WeekYear(Date) as WeekYear;
LOAD Date(MakeDate(2012)+IterNo()-1) as Date
AutoGenerate 1
While MakeDate(2012)+IterNo()-1<=Today();

hope this helps

regards

Marco