Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Tomajo
Contributor
Contributor

Related Items by Invoice in Sales.xlsx example

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?

 

1 Reply
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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)