topic Re: Prediction function in QlikView in QlikView

Prediction function in QlikView

Tue, 14 Jun 2011 09:17:17 GMT

Hello,

I was wondering if there is any function in QlikView which can predict, what data will be in the future in relation of data pattern?

I have already google it, but I didn't find anything useful. Maybe I wasn't looking with correct string.

Thank you,

Luka S.

Re: Prediction function in QlikView

IAMDV — Tue, 14 Jun 2011 10:31:21 GMT

Luka - Have you tried using Forecast option (works for charts) in the Axes tab. Here is the definition from the documentation.

Forecast

By checking this box and entering an integer in the edit

box, you force the x-axis to be extended to the right of the

actual data points plotted. This is useful when using trendlines.

The forecast line will be dotted.

Hope this helps!

Cheers - DV

Prediction function in QlikView

Tue, 14 Jun 2011 10:48:17 GMT

Thank you very much!

Re: Prediction function in QlikView

IAMDV — Tue, 14 Jun 2011 11:04:09 GMT

Luka - You are welcome! I am also attaching an example of using Forecast. I hope it will be useful.

Cheers - DV

Prediction function in QlikView

Tue, 14 Jun 2011 13:35:25 GMT

Hi DV

Just looking at same ,

I have a line chart which has Expression date and the demensions are Number of activities and Number of people.

If I wanted to forecast on my chart I need to check forecast button and now when you say integer ( Im sorry my background is not maths !!) what would that need to say as such ?

Can you help me

Prediction function in QlikView

Tue, 14 Jun 2011 13:38:57 GMT

Oh sorry DV

I meant to say I can not open your file as I only have personal edition at the moment !!

So I couldnt just go in and try and figure it out!!

Thanks

Re: Prediction function in QlikView

IAMDV — Tue, 14 Jun 2011 13:42:49 GMT

Hi,

Integer can be any number. In my example we are using month as dimension and I had used 4 as an example to predict the values for next 4 months. Sameway based on your requirement you can enter a number. I hope this is what you need.

Cheers - DV

Re: Prediction function in QlikView

Tue, 14 Jun 2011 13:59:57 GMT

Hi DV

My Dates (Demension) are based on days and I have put 15 ( looking to get a further 15 days forecast) when I apply it to chart the X axis just extends but the plotting on the graph does not change , do I need to calculated the forcast manually ?

Re: Prediction function in QlikView

IAMDV — Tue, 14 Jun 2011 14:08:20 GMT

Hi Mate,

Please look at the attached screenshot. I think you have not enabled the Trendline option. I have selected Linear as an option, based on your requirement you can select one of them.

Hope this helps!

Cheers - DV

Re: Prediction function in QlikView

Tue, 14 Jun 2011 14:10:58 GMT

Perfect DV

Thanks

Re: Prediction function in QlikView

IAMDV — Tue, 14 Jun 2011 14:22:42 GMT

Excellent!

Re: Prediction function in QlikView

slwasson — Mon, 27 Jun 2011 20:13:27 GMT

Hello DV,

Great example - it's very helpful to see a QVW. One question: Do you know how to show the forecast dimension labels along the x axis? In your example, they would be: 9, 10, 11 and 12.

Re: Prediction function in QlikView

IAMDV — Tue, 28 Jun 2011 08:32:57 GMT

I am glad this is helpful. Although the example was created by fellow expert member

I have not tried this but my first though is to uncheck the "Surpress the zero Value" option in presentation tab. Hope this should work.

Cheers - DV

Re: Prediction function in QlikView

slwasson — Tue, 28 Jun 2011 16:30:22 GMT

Many thanks for responding so quickly!

Good news and bad news about unchecking "Suppress Zero-Values."

Good news: It does indeed show the forecast dimension labels along the X axis.

Bad news: It causes the forecast line to be incorrect.

Any other suggestions?

Thank you,

Stacy W.

Re: Prediction function in QlikView

IAMDV — Wed, 29 Jun 2011 08:35:48 GMT

Hi Stacy,

You are welcome. I thought it would work but thats not the best solution. Have you tried to check the "Continuous" CheckBox under Axes Tab > Dimension Axis > Continuous Check Box.

"Suppress Zero-Values" will show up all the dimensions which have 0 or null values. So that's not the best way to do it. If the Continuous Check Box dont work then only thing I can think is to overlay one more copy of the chart with transperency as 100% to show all the 12 months (Not a neat solution but I had used this technique in the past).

I hope this makes sense!

Cheers - DV

Re: Prediction function in QlikView

slwasson — Wed, 29 Jun 2011 16:29:33 GMT

Thanks, DV. I'll give the overlay a try. If I come up with another solution, I'll let you know!

Stacy W.

Re: Prediction function in QlikView

IAMDV — Thu, 30 Jun 2011 08:15:20 GMT

Thank you Stacy. Please let me know the outcome.

Good luck!

Cheers - DV

Re: Prediction function in QlikView

slwasson — Thu, 30 Jun 2011 15:07:45 GMT

Hello DV,

I contacted tech support, and was told that the display along the X axis works only with a dimension that is a number (or date) - which makes sense now that I think about it.

I was using strings that depict fiscal quarters (e.g., FY11_Q1, etc.), so the forecast quarters were null along the X axis. If I use Dual and quarter end (or start) dates when loading the fiscal quarter string, I can display the forecast dates.

You were absolutely correct about checking "Continuous," and the overlay concept might work - I haven't tried it yet because I think that the display of months will probably suffice.

Attached is a file showing the use of the dual value.

Thanks again for your help!

Stacy W.

Re: Prediction function in QlikView

IAMDV — Thu, 30 Jun 2011 16:20:51 GMT

Stacy - Thank you very much for the update. Very true, we need to use only dimensions with numeric values or dates (QV interprets the dates as numbers ). So it won't work with string data type values. This is where the use of Dual() functions come handy!!

Many thanks again for taking time to update me & other users.

Cheers - DV

Re: Prediction function in QlikView

rajni_batra — Fri, 12 Jul 2013 12:06:09 GMT

Hi,

Can this be done is pivot?

Actually i need to forecast data from Jul 2013 till jul 2014 based on average of data for 2012 and 2013.

Can anybody plz help me on this... bit urgent

Regards,

Rajni