Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Reuven12
Contributor II
Contributor II

Calculation Sales growth

Hey all,

So I got a problem. I need to calculate sales number according to percentage growth of one year.

So for example my data contain that in 2022 my sales are 400 and the growth is 10 percent. 

I want to calculate for each year how much the sales gonna be, so for 2023 440 and for 2024 484.and so on.

I can't right It on the script cause the numbers need change by the user.

Is there any way to calculate it?

1 Reply
anthonyj
Creator III
Creator III

Hi @Reuven12 ,

The calculation for compounding increases in Qlik uses the Pow( ) function. 

anthonyj_0-1635718421447.png

Projected 1 Year = sum(num(Amount * pow(1 + 0.1, 1)))

Projected 2 Year = sum(num(Amount * pow(1 + 0.1, 2)))

Projected 3 Year = sum(num(Amount * pow(1 + 0.1, 3))) 

etc...

I'm not sure what you meant by the numbers changing per user, but this can be a start.

I hope it helps.

Thanks

Anthony