Year on Year Growth

[shwetagupta]

Hi All,

Read many of the content on community but haven't got the solution,

I am calculating growth of this year to last year (2014 and 2015),

Current Year Sales= sum({< REPORT_YEAR = {"$(=Max(Year([DATE])))"}>} MRP_VALUE)

Previous Year Sales = sum({< REPORT_YEAR = {"$(=Max(Year([DATE]))-1)"}>} MRP_VALUE)

Problem is : In result Current year sales =  Current +Previous year sales.

It is not giving me sum of the current year only !!!

i.e Whenever I make selection over year for eg: 2015 or 2014 it provide the correct result.

My all the dates lies in the single column

Can Anyone please suggest what is the problem and how can it be rectified.

[sunny_talwar]

How are DATE and REPORT_YEAR fields linked to each other?

[shwetagupta]

Hi Sunny T,

Thanks a lot for your this question.

Actually I was doing a blunder mistake while working which I noticed after your question, I picked up a wrong field name.

Now sorted ..

Thanks again for your time and Reply

[sunny_talwar]

Great,

Please mark the thread as closed.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny