Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

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
Highlighted
MVP
MVP

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