Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

itzel_inter1
New Contributor

Graph of future sales forecast based on historical QlikSense

GraficaSO.JPG 

 

Hello, I request your kind support to create in QLIKSENSE a trend graph (or forecast) of sales based on the weekly sale of the previous weeks of 2018, the graph I have is the following and what I do not want is to see that drop to zero in the following weeks, if not rather a forecast that is made based on the average of the previous weeks.

 

 

In excel you get with this formula

 

 

= YES (SUM (AV27: AV7498) <= 0, AVERAGE ($ AR25: $ AU25), SUM (AV27: AV7498))

 

In Qlik Sense I do not have how to assign that value in that way because obviously I do not have data loaded for future weeks ...

 

I hope you have explained me well and that someone can guide me.

 

Thank you very much.

 

4 Replies
ogautier62
Valued Contributor II

Re: Graph of future sales forecast based on historical QlikSense

Hi,

what's the rule/formula for forecast in english (we hav'nt values of what are meaning cells) ?

regards

vikasmahajan
Honored Contributor III

Re: Graph of future sales forecast based on historical QlikSense

PFA attached sample.

Vikas

ogautier62
Valued Contributor II

Re: Graph of future sales forecast based on historical QlikSense

I don't see attachement !

itzel_inter1
New Contributor

Re: Graph of future sales forecast based on historical QlikSense

Thanks for reply Olivier, what I need Is the same that I show you below, the formula (in english) in Excel is:

=IF(SUM(AV27:AV7498)<=0,AVG($AR25:$AU25),SUM(AV27:AV7498))

and the graphic that I need is like this :

graficaexcel.JPG

What I need to do in QLikSense is the values in the line marked in yellow ( is the forecast).

My example in excel is like this:

CapturaExcel.JPG


I hope I have explained yo well...

Thanks a lot

Community Browser