If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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)