Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 (1)
0 Replies