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: 
Logistix
Contributor II
Contributor II

How to get the amount of sales by client

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 

IdClientFull NameAgeIdSale
01

Helen 

2201
02Janet 3702

 

Sales table 

IdSaleIdProductquantity 
01013
02021

 

Product Table 

IdProductDescription PriceU
01Mouse15$
02TV400$

 

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.

 

Labels (2)
1 Solution

Accepted Solutions
Kushal_Chawda

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)

View solution in original post

1 Reply
Kushal_Chawda

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)