topic How to calculate forecast deviation in QlikView

How to calculate forecast deviation

Thu, 10 Jun 2010 19:48:15 GMT

Hi,

I would like to calculate the forecast deviation between two forecasts. I have a field called Sales Forecasts that contains several different forcasts 'F1 2010', 'F2 2010', 'F3 2010' with sales data. How do I write an expression to calculate the deviation (eg. F2-F3) given my selection. That is, an expression that subtract the data from one selection from the other one (eg F1-F3)

Thank you

Regards

Glenn

How to calculate forecast deviation

pover — Fri, 11 Jun 2010 04:49:51 GMT

Try the following:

sum({'$(=minstring(Forecast_Period))'} Amount) - sum({'$(=maxstring(Forecast_Period))'} Amount)

Regards.

How to calculate forecast deviation

Fri, 11 Jun 2010 04:59:08 GMT

Hello,

you could try sets, e.g.,

Count( {F1} Sale) - Count( {F3} Sale)

gives count of sales in set or bookmark "F1" - count of sales in set F3.

FYI

Count( {F1-F3} Sale)

counts sales that exist in set F1 but do not exist in F3

Greetings,

Piet

How to calculate forecast deviation

Fri, 11 Jun 2010 06:14:00 GMT

Hi Glenn,

I hope that i have understand your issue. Herewith i have attached an application for your reference.

Regards

Rajeh

How to calculate forecast deviation

Mon, 14 Jun 2010 18:17:24 GMT

Thanks for all replies, everything works fine now.

Rajesh, your file was very helpful. Thank you!

Regards

Glenn