Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
alis2063
Creator III
Creator III

Set Analysis to used to show 10 % increase as per current Sales by month

Hi Guys,

Actually ,i need to show 10% increase of Sales  by Month which depend on 2019 sales as below  

The calculation of budget 2019 is

Jan-48566

Feb-(48566*10)/100+48566=58764

March-(58764*10)/100+58764=64641.35

Sales .jpg

2 Solutions

Accepted Solutions
sunny_talwar

Two options

1)

If(RowNo() = 1, Sum(Sales), Above([10% Budget]) * 1.1)

2)

Exp(RangeSum(Above(log(1.1), 1, RowNo()))) * Sum(TOTAL {<Month = {'Jan'}>} Sales)

image.png

View solution in original post

sunny_talwar

Basically, we are doing like this

Jan - 1
Feb - 1.1
Mar - 1.1 * 1.1
Apr - 1.1 * 1.1 * 1.1

So, in order to accumulated multiplication, I am using Log function which can then be added and then brought back to its original form using exp() function.

View solution in original post

11 Replies
gf
Creator III
Creator III

Like this?

gf
Creator III
Creator III

Sorry, change expression to
=SUM([2019])*1.1
alis2063
Creator III
Creator III
Author

No its note like that.

 

It would considered 10 % increase over previous record.

 

Regards,

Ali

gf
Creator III
Creator III

This should work as expected:
=If(PNRMonth='Jan',Sum([2019]),above(Total Sum([2019])*1.1))
alis2063
Creator III
Creator III
Author

Thanks for your help.

 

But it would not fulfill my requirement as calculation is based on Initial values  e.g

10 % Increase over MONTH

Month  Sales10 % Budget---This is result
Jan100110
Feb82120
Mar120130

      

@sunny_talwar -Could you please help me for above requirement

 

sunny_talwar


@alis2063 wrote:

 

Month  Sales10 % Budget---This is result
Jan100110
Feb82120
Mar120130

 


How are you getting 10% Budget column in this example? 110 seems to be 100 * 1.1, but how is 120 and 130 getting calculated here?

alis2063
Creator III
Creator III
Author

Sorry for Jan Month it would be same & calculation would be just as below

 

Month  Sales10 % Budget---This is result
Jan100100
Feb82110=(100*10)/100+100
Mar120121=(110*10)/100+110
sunny_talwar

Two options

1)

If(RowNo() = 1, Sum(Sales), Above([10% Budget]) * 1.1)

2)

Exp(RangeSum(Above(log(1.1), 1, RowNo()))) * Sum(TOTAL {<Month = {'Jan'}>} Sales)

image.png

alis2063
Creator III
Creator III
Author

Thanks Sunny 

 

you are awesome man!!!