custom joining tables

[Isabelaa_123]

Hi,

I need help joining two tables. I'm not fluent in Qlik yet

First table, this is my main table

date

number SKU

property SKU

name SKU

sales

Second table:

date

number SKU

category

sales_percentage

After combining two of these tables with a key, I would like to see how many SKUs were sold in a particular category. I can't do this through the function applymap.

Multiplication and addition also do not give satisfactory results. Anyone have any ideas?

Thanks

[vinieme12 · Accepted solution]

You can left join first and second table to create one single table

Can you post some sample data in excel that best represents your actual data

What is the relationship type between these tables  1-to-many,   many-to-many   or 1-to-1??