Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to calculate forecast deviation

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

4 Replies
pover
Luminary Alumni
Luminary Alumni

Try the following:

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

Regards.

Not applicable
Author

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

Not applicable
Author

Hi Glenn,

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

Regards

Rajeh

Not applicable
Author

Thanks for all replies, everything works fine now.

Rajesh, your file was very helpful. Thank you!

Regards

Glenn