Growth rate

[Pranit4e]

I used above function to calculate growth rate against dimensions (Year, Month and Quarter). Here qlik automatically projects growth rate for periods not listed in the year, month and quarter. How to deactivate the same? Here 2018 does not exist. Still i get projections for 2018

[sugisense]

Try Untick Include Zero Values in Data handling option.

[Pranit4e · Accepted solution]

Hi

Thankyou for your reply

Did that.. It just puts away the zero as values

Num (Sum(Revenue)/Above(Sum(Revenue)) -1, '#,##0.00%') * Avg(1)

Have tried this expression. It helps. Now the only problem is to figure out how to get back my % value

[Pranit4e · Accepted solution]

Hi

And i have resolved the issue 🙂

Thank you 🙂