Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Isabelaa_123
Contributor II
Contributor II

custom joining tables

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

 

Labels (4)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

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??

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

1 Reply
vinieme12
Champion III
Champion III

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??

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.