topic Re: Generating forecast data in QlikView

Generating forecast data

Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys

I have scenario

I have a data like below

Year Sales

2011 234

2012 456

2013 342

2014 476

2015 435

2016 982

from

2017 2016 sales value+(2016 sales value*1%)

2018 2017 sales value+(2017 sales value*1%)

2019 2018 sales value+(2018 sales value*1%)

This percentage value is dynamic it is coming from my input box Sales growth Rate

And i want to this calculations in my front end not in script(since the variable value will be selected by end user).
So i want to do this in my chart expressions.

Is there any way to this.

Please do the needful

Thanks

Thiru

Re: Generating forecast data

sunny_talwar — Wed, 27 Jul 2016 11:34:50 GMT

Try this expression:

=If(Year <= Year(Today()), Sum(Sales), Above(Column(1)) * 1.1)

Where Column(1) is your first expression

Re: Generating forecast data

Wed, 27 Jul 2016 12:58:57 GMT

Hi Sunny

Thanks

It's working

Thiru

Re: Generating forecast data

Tue, 02 Aug 2016 07:37:00 GMT

Hi Sunny

Is there any other way to do directly with out if and with out column() functions

Now

=If(Year <= Year(Today()), Sum(Sales), Above(Column(1)) * 1.1)

I need

= Above(Sum(Sales)) * 1.1)

Thiru

Re: Generating forecast data

sunny_talwar — Tue, 02 Aug 2016 09:52:40 GMT

You want the same result, but you want to do without using if and Column() function?

Re: Generating forecast data

sunny_talwar — Tue, 02 Aug 2016 10:07:49 GMT

Here is another method you can try:

RangeSum(Sum({<Year = {"$(='<=' & Year(Today()))"}>}Sales),

Above(Sum({<Year = {"$(='>=' & Year(Today()))"}>}Sales), RangeMax(RowNo() - Year(Today()) + Min(TOTAL Year) - 1, 1)) * pow(1.1, RowNo() - Year(Today()) + Min(TOTAL Year) - 1))

Re: Generating forecast data

Wed, 03 Aug 2016 11:39:33 GMT

Hi Sunny

How to use

this

=If(Year <= Year(Today()), Sum(Sales), Above(Column(1)) * 1.1)

in text box objects?

Thiru

Re: Generating forecast data

sunny_talwar — Wed, 03 Aug 2016 11:42:46 GMT

What number/numbers do you want to see in the text box?

Re: Generating forecast data

Wed, 03 Aug 2016 11:48:54 GMT

Hi Sunny

It's not numbers based on this values i need to get that date,As per our old discussion for crash date actual vs target

here using this i need to get that Crashdate and Actual date.

action date on chart based on max value

Regards

Thiru

Re: Generating forecast data

Thu, 04 Aug 2016 10:00:11 GMT

Hi Sunny

I have created a variable which is =Year(Today)

so wherever you used Year(Today) can you please replace with V_YEAR variable and try it

Please do the needful

Regards

Thiru

Re: Generating forecast data

Thu, 04 Aug 2016 10:43:01 GMT

HI Sunny,

to adding to the above my data is not having years it is monthly based records

like 2016-JAN-01

2016-FEB-01

2016-MAR-01

2016-APR-01

2016-MAY-01

2016-JUNE-01

2016-AUG-01

beacuse you mention in the code it is max(rowno()-year(today()), so here 230-2016 but my scenario 230-2016-JULY-01 may not work

Please do the needful

Thiru