Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What exactly is wrong here? Would you be able to pin point the issue?
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.
Would you be able to share a sample to check this out?