Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted
Specialist III
Specialist III

just use week(date) as ur dimension

Channa
Highlighted
Partner
Partner

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.