topic Re: predictive modelling in qlikview in QlikView

predictive modelling in qlikview

Fri, 25 Nov 2011 04:32:54 GMT

Can any one implemented predictive modelling techniques in Qlikview

predictive modelling in qlikview

Fri, 25 Nov 2011 05:23:54 GMT

Yes, we do a lot of perdictive analysis at our company.

Kiran

Re: predictive modelling in qlikview

agigliotti — Wed, 12 Dec 2012 11:16:45 GMT

Hi Kiran,

Could you please give me more informations about integrating predictive analysis in QlikView ?

I tried to use R with QlikVIew (clustering analysis), but I need more examples on this topic.

Can you help me?

Thanks in advance.

Best regards

Andrea

Re: predictive modelling in qlikview

perumal_41 — Wed, 12 Dec 2012 11:19:50 GMT

Hi,

Chech this link get more information

http://community.qlik.com/thread/65224?tstart=0

Re: predictive modelling in qlikview

Wed, 12 Dec 2012 12:10:44 GMT

Integration with R, the cluster analysis is good enough. It demos how to send data to R, execute R commands and get R output. If you want more examples, try basis R tutorials available in youtube.

Analysis to analysis these R commands differ for which R expertise is required. I can if you have any specific issues.

Kiran.

Re: predictive modelling in qlikview

agigliotti — Wed, 12 Dec 2012 13:44:55 GMT

I'm interesting on association analysis (discover what items are bought together) and sales forecasting.

Do you have some experiences on those topics?

I started to use R (with QlikView) only few days ago so I'm not expertise in this programming language.

Thanks.

Regards

Andrea

Re: predictive modelling in qlikview

Thu, 13 Dec 2012 03:49:12 GMT

Association analysis can be done within qlikview. Refer basket analysis in online tutorials.

For forecasting there are many algorithems but you can use holtwinters() function in R. You can find more about it over web. No need to be expert at R to do these. Getting the first app is difficult and the rest follows easy. Good Luck.

Kiran Rokkam.

Re: predictive modelling in qlikview

agigliotti — Thu, 13 Dec 2012 09:31:25 GMT

Hi Kiran,

thank you for your suggestions.

for association analysis I mean a data mining algorithm, see the following post:

---

As far as I know, this frequent itemsets data mining is not (yet) implemented straight forward in QlikView, as there is no function to get support and confidence for itemsets combinations.

Combinations calculations can be done in the underlying database using APRIORI algorhytm :

ORACLE :

http://download.oracle.com/docs/cd/B28359_01/datamine.111/b28129/market_basket.htm#BABEEGCB

SQL Server :

http://msdn.microsoft.com/en-us/library/cc280428.aspx

---

I need to create a sort of matrix as below:

can you guide me to the right direction to achieve it ?

many thanks for your help in advance

best regards

Andrea

Re: predictive modelling in qlikview

Fri, 14 Dec 2012 10:00:31 GMT

Hi Andrea,

I guess there is no direct or simple way for this QlikView. But at this point I can think about a workaround which is long but would help you to some extent.

For some strange reason I am not able to upload the file. But I will try to describe the solution. Let us consider retail invoices as the data source. Each invoice has products and qty from which the above chart should be generated.

Solution:

Create two tables: Invoice and InvoiceDuplicate. Invoice table will have all the invoice details eg. InvoiceNo,Item,Qty,Price,Value etc. Invoice Duplicate will have only fields InvoiceNo and Item2 (alias of Item).

Create a chart with Item, Item2 as dimensions and Count(distinct InvoiceNo) as Expression. You can add background colors based on conditions to achieve the above.

Regards,

Kiran Rokkam.