Related Items by Invoice in Sales.xlsx example

Tomajo — Sat, 27 Feb 2021 08:27:54 GMT

Hi:

I asking myself how I could know related items by Invoice. The idea es know which items people buy together.

If I use SQL I can try a Self Join for Sales table.

I googled for "Self Join Qlik" and It seems there is no natural way to do that.

Maybe there is a natural way to do what I want, but it's not through a self join.

Any ideas?

Re: Related Items by Invoice in Sales.xlsx example

Anil_Babu_Samineni — Sat, 27 Feb 2021 19:28:10 GMT

Hello, Welcome to Qlik !

Qlik will read direct SQL queries as well. If you want to convert Self Join into Qlik off course, That is good choice.

When you say self join how your query looks like? Because, In Qlik Self join is by default join only hence It will be performed normal way