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: 
arjuna123
Contributor
Contributor

Customizing date range filter in Qlik hub (10 days, 14 days, etc)

I'm trying to create a chart in Qlik where the x-axis iterates data by every 2 weeks for the past year. Can anyone help with this?

Labels (2)
1 Reply
edwin
Master II
Master II

it will be easier if you can identify when the first week of the year starts, then just add 14 days to that.  you should be able to get the start and end of your 14-day cycle.  you can then combine this will your calendar and use either a week index  W1, W2, etc.. or the start of each cycle as a new dimension

use this dimension as your x axis

load date(FirstWeek + (iterno()-1)*14) as WeekStart, date(FirstWeek + iterno()*14 -1) as WeekEnd, 'W'&iterno() as WeekNumber while year(date(FirstWeek + (iterno()-1)*14))=2020;
load date('1/1/2020') as FirstWeek AutoGenerate (1);

 

edwin_0-1613612990081.png

 

 

this is a sample to generate the weeks then you can use a couple of ways to join this to your calendar.  either do joins or intervalmatch