topic Issue with Y/Y in chart in QlikView

Issue with Y/Y in chart

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Currently my chart looks like below because 2016 has data for all the 53 weeks but 2017 only has data for 10 weeks. So I want to get rid of weeks greater than 10 in 2016.

My dimension is Week Of year

And my measures are:

Max Year = sum({<Year={'$(=Max(Year))'}>}Amt)

Max year -1 = sum({<Year={'$(=Max(Year)-1)'} , DATE={'<=$(=AddYears(max(DATE), -1))'} >}Amt)

Am I missing something?

Re: Issue with Y/Y in chart

vishsaggi — Wed, 26 Apr 2017 20:57:41 GMT

Can you share a sample app to work on. ?May be try like: I am not sure have not tried

Max year -1 = sum({<Year={'$(=Max(Year)-1)'} , DATE={'<=$(=AddYears(max(DATE), -1))',

[Week of Year] = {'$(= [Week Of Year] < 11)'} } >}Amt)

Re: Issue with Y/Y in chart

Anil_Babu_Samineni — Thu, 27 Apr 2017 01:02:00 GMT

As provide seems ok to me. But, You are talking about Week might you missed Week on your query