topic How to calculate Growth% in QlikView

How to calculate Growth%

sakshikaul — Wed, 25 Nov 2020 16:16:04 GMT

I want to calculate the growth% but this is giving me a wrong result

To calculate growth% formula should be

Current year- Previous year/Previous Year

I am applying same formula here its not giving correct results.............

= num((sum({StateB < Sold_Date = {">=$(sstart)<=$(eend)"} >}quantity_sold )-(sum({StateB < Sold_Date = {">=$(sstart)<=$(eend)"} >}quantity_returns )

(sum({ stateA< Sold_Date = {">=$(From)<=$(To)"} >}quantity_sold )-(sum({stateA < Sold_Date = {">=$(From)<=$(To)"} >}quantity_returns )

Sum({stateA< Sold_Date = {">=$(From)<=$(To)"} >} quantity_sold)-(sum({ stateA< Sold_Date = {">=$(From)<=$(To)"} >}quantity_returns )))))), '#,##0.0')

m_woolf — Mon, 13 Aug 2018 12:36:53 GMT

Your formula is missing parentheses:

(Current year- Previous year)/Previous Year

BalaBhaskar_Qlik — Mon, 13 Aug 2018 14:39:34 GMT

Try this:

= num((sum({StateB < Sold_Date = {">=$(sstart)<=$(eend)"} >}quantity_sold )

sum({StateB < Sold_Date = {">=$(sstart)<=$(eend)"} >}quantity_returns )

sum({stateA < Sold_Date = {">=$(From)<=$(To)"} >}quantity_sold )

sum({stateA < Sold_Date = {">=$(From)<=$(To)"} >}quantity_returns ))

(Sum({stateA < Sold_Date = {">=$(From)<=$(To)"} >}quantity_sold)

sum({stateA < Sold_Date = {">=$(From)<=$(To)"} >}quantity_returns )), '#,##0.0')