Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
just use week(date) as ur dimension
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.
Hi you need to deal this with master calendar
https://community.qlik.com/t5/New-to-QlikView/How-to-generate-weeks-between-two-dates/td-p/1438491