New to Qlik Sense

[Logistix]

Hello, I’m pretty new on Qlik Sense and I’m trying to get the amount of sales by client with the data model below. 

Client Table 

IdClient	Full Name	Age	IdSale
01	Helen	22	01
02	Janet	37	02

Sales table 

IdSale	IdProduct	quantity
01	01	3
02	02	1

Product Table 

IdProduct	Description	PriceU
01	Mouse	15$
02	TV	400$

My data model is like this, which I imported from an Excel Sheet. I don’t know how to calculate the sales amount by client.

[Kush · Accepted solution]

You can create the data model based on Key highlighted 

You can link the tables like below

Sales_table:
load IdSales,
IdProduct,
quantity
FROM Source;

left join(Sales_table)
load IdProduct,
Description,
Price
FROM Source;

Client_table:
load IdClient,
FullName,
Age,
IdSale
FROM Source;

You can now create chart with any dimension like Description, IdClient, FullName and put below measure

sum(quantity*Price)