Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

shwetagupta
Contributor

Year on Year Growth

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.

3 Replies
MVP
MVP

Re: Year on Year Growth

How are DATE and REPORT_YEAR fields linked to each other?

shwetagupta
Contributor

Re: Year on Year Growth

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

MVP
MVP

Re: Year on Year Growth

Great,

Please mark the thread as closed.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny