Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
arindam_bhadra
Contributor II
Contributor II

Week Range on chart

Hi Team,

I am new to Qlik and I am stuck on a chart representation. In my chart I am trying to show an YOY for current and previous year on weekly basis. The codes for the measures are as follows:

Curr Year: sum({<Table_Flag={'Funnel_Stage_New'}, DATE_OVERALL= {">=$(=Min(DATE_OVERALL))<=$(=Max(DATE_OVERALL))"}>} nbr)

Prev Year: sum({<Table_Flag={'Funnel_Stage_New'}, DATE_OVERALL= {">=$(=Min(PreYear))<=$(=Max(PreYear))"}> } nbr)

and the dimension is 

=Date(WeekStart(DATE_OVERALL),'MMM DD')&' - '&(Date(WeekEnd(DATE_OVERALL),'MMM DD'))

As it is present on the chart that the week ranges are not in alignment for both the year. I need a solution to put the week range same for both the years. Please suggest solutions.

The date range is from Sept 1 to Sept 30. 

Thanks

Capture.PNG

Labels (4)
0 Replies