Discussion board where members can get started with Qlik Sense.
Iam a new user of Qlik, and little bit lost. Iam trying to do a SUM of one field based on unique items of another field.
Column Order_Num contains numbers of order, but multiple times, based on how many items was sold in each order. How can I sum the Taxed_price only for unique Order_Num - I want to use it like mesure in chart that will show amount of order sales per month for exemple.
thx for answer, but it doesnt work.
What I need, is to SUM unique prices for each unique order to put them into chart per date. So the expected output is chart with Januray - orders for 1543,26... then february and so on...
in the excel I have to make a pivot table first to have unique min or max amounts (cause they are same per order) of orders, then put in a new table with date fields and then make a chart with theese data. Think in qlik it should be much easier, just find the right way 🙂
If you want the chart by Month then you need to create the Month Field in your Data. I would suggest to create Master calendar and link it with buy_date, but for example I have created Month field in your data
date(date#(buy_date,'YYYY-MM-DD')) as buy_date,
month(date#(buy_date,'YYYY-MM-DD')) as Month
(ooxml, embedded labels, table is Hárok1);
Now you can create chart with Dimension Month & Below expression. If you want to create chart by Date then replace Month in below expression with buy_date = sum(aggr(max(taxed_price),order_num,Month))