how to create 'inner join' for the 2 data set

[Anonymous]

Hi

Wondering, how could i do the inner join for 2 dataset?

after I join the data from 'data Manager'  and then load. I went to 'data load editor'.

did not find any where i can put

'inner join' or see the data sets 'joined'

problem is. there are some empty line in the data set

when i do pivot table , then the 'Empty' row become one separate line.

I have same issue if I use the bar chart.

How could I solve this issue?

Thank you!

[sunny_talwar]

both?

[Anonymous]

Yes. with and without the first and the third lines:

........

[Pluhierarchy]:

Inner Keep ([Stockholm3store7dayPlu])

.......

[StoreLocation]:

Inner Keep ([Stockholm3store7dayPlu])

.......

Seems it does not work. I am using Qlik sense cloud. not the desk top

[sunny_talwar · Accepted solution]

I am not really sure what might be happening, what I gave you was the syntax for Inner Join and Inner Keep. May be someone else can offer better help here