Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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)