Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Ozturkec
New Contributor

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

Hello, 

I need urgent help! This is my pivot table:qlikekran.png

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

3 Replies

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

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

Ozturkec
New Contributor

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

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.

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

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