Related Items by Invoice in Sales.xlsx example

[Tomajo]

Hi:

I'm new to Qlik Sense, and I am trying to learn from the Tutorials: https://help.qlik.com/en-US/sense/November2020/tutorials/Tutorial%20-%20Building%20an%20App.zip

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?

[Anil_Babu_Samineni]

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