How can I show and calculate growth rate amount from pivot table

[Ozturkec]

Hello, 

I need urgent help! This is my pivot table:

Growth rate calculation is: (sum(quantity)/sum(Prev_QuantityAC)-1)

Prev_QuantityAC  is my one previous week sales amount.

I used Qlik master calendar and [Tarih.Calendar.WeekYear] is my week-year date format.

I want to show average growth rate of current week in KPI object. Could you help me?

I tried this set analysis but it is nor working :

sum({1<[Tarih.Calendar.WeekYear]={1$(=Max([Tarih.Calendar.WeekYear]))}>+<quantitiy={">0"}>} quantitiy)
/
sum({1<[Tarih.Calendar.WeekYear]={1$(=Max([Tarih.Calendar.WeekYear]))}>+<quantitiy={">0"} >}Prev_QuantityAC)-1

[sunny_talwar]

What exactly is wrong here? Would you be able to pin point the issue?

[Ozturkec]

If I select exact date in term of week-year, it gives me true result. But if I do not select any date, this set analysis gives an wrong result.

[sunny_talwar]

Would you be able to share a sample to check this out?