How to Get Week Range as Dimension from two dates? - Qlik Community

vikalp19 · ‎2019-03-29

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.

Channa · ‎2019-03-30

just use week(date) as ur dimension

Channa

vikalp19 · ‎2019-04-01

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.

Channa · ‎2019-04-01

Hi you need to deal this with master calendar

https://community.qlik.com/t5/QlikView-App-Development/MonthName-between-Start-Date-and-End-Date/td-...

https://community.qlik.com/t5/New-to-QlikView/How-to-generate-weeks-between-two-dates/td-p/1438491

Channa