Discussion board where members can get started with Qlik Sense.
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
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,quantityFROM Source;
left join(Sales_table)load IdProduct,Description,PriceFROM Source;
Client_table:load IdClient,FullName,Age,IdSaleFROM Source;
You can now create chart with any dimension like Description, IdClient, FullName and put below measure
View solution in original post