Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

RANGE SUM function is not working if i use two times

HI

I have scenario

I am using rangesum function for one input column

Rangesum(above(sum(Sales_Impact),0,240))  (Sales_Impact column is input column)


It is working fine



But i want use one more rangesum like below


(Sales+Rangesum(above(sum(Sales_Impact),0,240))+Rangesum(above(sum((((Sales+Rangesum(above(sum(Sales_Impact),0,240)))*$(SalesAnnual Growth Rate))/100)),0,240)) )

If i use two times it is not working.

Please do the needful

Actual scenario is

I need to generate forcast data using above formula

Date                  sales

2016-JAN-01    1200

2016-FEB-01     1400

2016-MAR-01    1500

2016-APR-01     1750

2016-MAY-01       1800

2016-JUNE-01    2000

2016-JULY-01      2150

Forcast

2017-AUG-01      2150+Rangesum(above(sum(Sales_Impact),0,240))+                           Rangesum(above(sum((((2150+Rangesum(above(sum(Sales_Impact),0,240)))*                                                                           

$(SalesAnnual Growth Rate))/100)),0,240)) ))

here it is $(SalesAnnual Growth Rate) is inputbox  which is avaraible.

Thanks

Thiru

3 Replies
Highlighted

Was this not a good solution here?

Re: Generating forecast data

Highlighted
Not applicable

Hi Sunny,

It is a good solution.but since i am new to qlikview and my code is bigger and your code is a little big.SO not able to under stand how to implement in my scenario

Any way i am trying now.i will let you know once it is done

Thanks

Thiru

Highlighted

Sure thing