topic Re: Search association rules in QlikView

Search association rules

vtatarnikov — Thu, 14 May 2015 08:14:48 GMT

Hello! Give please advice on the creation of recommendations.
I have found a pair of items that bought in succession within three months.
Table 1 - is the purchases of a particular client. How to create a table 2?
I plan to find a pair of goods and calculate the frequency of their occurrence.
In the right direction I move?
I would appreciate any advice!

In Table 1, are: the date of the check, id of the check, products in check.

In Table 2, there are a pair of products:

Product 2=b (id_product=b in the check=2 in table 1) has been sold after the Product 1=a (id_product=a in the check=1 in table 1) within 3 months ([date of id_document=2] deduct [date of id_document=1] <= 90 days)

etc.

Сообщение отредактировано: Vladislav Tatarnikov

Re: Search association rules

qlikviewwizard — Thu, 14 May 2015 08:20:31 GMT

What is the relation beteen id_product ,Product1 and Product2?

Re: Search association rules

vtatarnikov — Thu, 14 May 2015 08:26:06 GMT

Products B and C was sold after the product A within 3 months

Re: Search association rules

fvelascog72 — Thu, 14 May 2015 09:00:45 GMT

Hi, Vladislav,

Colud you be more specific explaining the relation between dates, ids and products fields.

Thanks,

Re: Search association rules

vtatarnikov — Thu, 14 May 2015 09:15:30 GMT

In Table 1, are: the date of the check, id of the check, products in check.

In Table 2, there are a pair of products: Product 2=b (id_product=b in the check=2 in table 1) has been sold after the Product 1=a (id_product=a in the check=1 in table 1) within 3 months ([date of id_document=2] deduct [date of id_document=1] <= 90 days)

etc.