topic Re: Bi weekly filter pane in QlikView

Bi weekly filter pane

Fri, 26 Aug 2016 19:49:42 GMT

Is it possible to create a biweekly filter pane? And who would I set the stop and start days?

Re: Bi weekly filter pane

maxgro — Fri, 26 Aug 2016 20:13:57 GMT

What's a biweekly filter pane?

Re: Bi weekly filter pane

Fri, 26 Aug 2016 20:17:36 GMT

I was hoping I could add it to my app and match the weeks to my payroll which is biweekly

Re: Bi weekly filter pane

Anil_Babu_Samineni — Sat, 27 Aug 2016 02:42:27 GMT

Robert, Bi weekly means - You want to show 45 Days Data / 15 Days Data?

Re: Bi weekly filter pane

MarcoWedel — Sun, 28 Aug 2016 00:41:37 GMT

Hi,

maybe something like this?

tabCalendar: 
LOAD *, 
    Day(Date) as Day, 
    WeekDay(Date) as WeekDay, 
    Week(Date) as Week, 
    WeekName(Date) as WeekName,
    Dual(DayName(Floor(Date,14,2))&' - '&DayName(Floor(Date,14,2)+13),DayName(Floor(Date,14,2))) as BiWeek,
    Month(Date) as Month,
    MonthName(Date) as MonthName, 
    Dual('Q'&Ceil(Month(Date)/3),Ceil(Month(Date)/3)) as Quarter, 
    QuarterName(Date) as QuarterName, 
    Year(Date) as Year, 
    WeekYear(Date) as WeekYear;   
LOAD Date(MinDate+IterNo()-1) as Date 
While MinDate+IterNo()-1 <= MaxDate; 
LOAD MakeDate(2014) as MinDate, 
    Today() as MaxDate 
AutoGenerate 1;

hope this helps

regards

Marco

Re: Bi weekly filter pane

Anil_Babu_Samineni — Sun, 28 Aug 2016 04:01:38 GMT

Marco,

Can you explain what it returns?

Dual(DayName(Floor(Date,14,2)) &' - '& DayName(Floor(Date,14,2)+13),DayName(Floor(Date,14,2)))

Re: Bi weekly filter pane

MarcoWedel — Sun, 28 Aug 2016 11:46:11 GMT

Hi,

It creates consecutive 14 days intervals represented by start and end date having a numerical value of the start date. The 2 weeks / 14 days are defined in the first parameter of the Floor() function. The second parameter adds an offset to let the intervals start on mondays.

Hope this helps

Regards

Marco

Re: Bi weekly filter pane

HirisH_V7 — Sun, 28 Aug 2016 12:44:57 GMT

Hi,

Can you please explain further or does marcowedel‌ post helps for your requirement I believe.

Thanks marcowedel for post and info.

-Hirish