# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for
Did you mean:  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 2 Solutions

Accepted Solutions  MVP

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)`   MVP

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.

11 Replies  Creator III

Like this?  Creator III
Sorry, change expression to
=SUM()*1.1  Creator III
Author

No its note like that.

It would considered 10 % increase over previous record.

Regards,

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

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

10 % Increase over MONTH

 Month Sales 10 % Budget---This is result Jan 100 110 Feb 82 120 Mar 120 130  MVP

@alis2063 wrote:

 Month Sales 10 % Budget---This is result Jan 100 110 Feb 82 120 Mar 120 130

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?  Creator III
Author

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

 Month Sales 10 % Budget---This is result Jan 100 100 Feb 82 110=(100*10)/100+100 Mar 120 121=(110*10)/100+110  MVP

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)`   Creator III
Author

Thanks Sunny

you are awesome man!!! 