Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Fortnight function

Is any fortnight function available like Week,Day etc.

4 Replies
Anonymous
Not applicable
Author

No but you could try something like

     round ( week ( today() ) / 2 )

anbu1984
Master III
Master III

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

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

ashfaq_haseeb
Champion III
Champion III

Hi,

Check this.

Regards

ASHFAQ

MarcoWedel

Hi,

maybe one solution could be:

QlikCommunity_Message_140471_Pic1.JPG.jpg

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