predictive modelling in qlikview

[#1]

Can any one implemented predictive modelling techniques in Qlikview

[#2]

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

Kiran

[agigliotti]

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

[perumal_41]

Hi,

Chech this link get more information

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

[#5]

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.

[agigliotti]

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

[#7]

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.

[agigliotti]

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

[#9]

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.