APRIORI algorithm (support, confidence lift)

[Guan_Achinech]

Hello All

I've been trying to create a data table based in expressions such as "support" "confidence" and "lift" for a market basket analysis in Qlik sense.

Let's say that I take this example attached:

Do you know the existence of any way to succeed to create it in Qlik sense?

Otherwise, would you kindly share some expressions and its syntax in order to achieve the variables (support, confidence, lift)?

BR

Guan

[chrismarlow]

Hi,

I am not sure you attached what you intended, image is just 8 rows of 2 columns of data (order id and product) ... not sure that gives folks a lot to go on.

Cheers,

Chris.

[Guan_Achinech]

Hi

I'd tried to simplify all the data with a same transaction for deafferents products.
Actually, I was wondering if is it there any way to create the expressions for each variable: support, confidence & lift.

I'm looking for a creation of a market basket analysis based on that.

Regards