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: 
vikalp19
Partner - Contributor
Partner - Contributor

How to Get Week Range as Dimension from two dates?

Hey Everyone,

I am working on a heat map and I need to have show week numbers on X-Axis based on Start Date and End Date. Any suggestions?

 

Thanks in advance.

3 Replies
Channa
Specialist III
Specialist III

just use week(date) as ur dimension

Channa
vikalp19
Partner - Contributor
Partner - Contributor
Author

Thanks for your response Channa. The Week(date) gives me specific week the date belongs to. What I am looking for is the week range.

 

So Lets say if my Start Date is 2/1/2019 and my end date is 3/1/2019 (MM/DD/YYYY), its roughly 4 weeks between these dates. So I want the X axis to show: 1, 2, 3, 4 as week number.