Qlik Community

Qlik Sense App Development

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

rohitk1609
Valued Contributor II

Problem in calculating Growth% by Month-Year

Hi Techies,

I am facing a problem while calculating growth% by Month-Year in Table chart. The result I am expecting is :

Month-Year  KPI Growth%

Jul-2017       A      10%(Val of Jul-2017 / Val of Jul-2016 -1)

Jul-2017       B      20%

Jul-2017       C      30%

Aug-2017     A      10%

Aug-2017     B      20%

Aug-2017     C      30%


Formula I am considerng is : July 2017 Sales/July 2016 -1


Please let me know how to do it


Thanks in advance

Best,

Rohit


Tags (1)
3 Replies

Re: Problem in calculating Growth% by Month-Year

And which type of chart you are using.

rohitk1609
Valued Contributor II

Re: Problem in calculating Growth% by Month-Year

tabular or pivot anyone but I need to use Month-Year dimension and one other dimension and in measure I need to find the growth as this month 2017 by this month 2016

Re: Problem in calculating Growth% by Month-Year

May be try with Variables or straight table will give correct result.

Community Browser