Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table with expression Customer, Txn Date, and Item. I want to display only the last 3 Txn Date per item per customer.
Try using Rank function. If you could not, please post a sample file with expected output
I need it to display only the last 3 sales transactions per customer per item.
I can not get a sample file to load
This is a sample report. I want to display only the last 3 sales transactions for each item per customer.
Try this,
tab1:
LOAD F1,
F2,
Date,
F4,
Num,
F6,
Name,
F8,
Item,
F10,
Qty,
F12,
[U/M],
F14,
[Sales Price],
F16,
Amount,
F18,
[Loaded Cost]
FROM
[C:\Users\sarav\Downloads\6-6-3 PAT TEST.xlsx]
(ooxml, embedded labels, table is Sheet1);
Left Join(tab1)
LOAD Name, Item, Date, AutoNumber(Name&Item&Date) As Rank
Resident tab1
Order By Name, Item, Date Desc;
You can use any Field in the place of Date here:
I still want it sorted the same way with the Customer first then sorted and grouped by item# and with the transaction dates descending. And show one column for the dates but only with the last 3 most recent dates for each transaction item per customer
I'm still waiting for assistance on this question. I don't think Rank will work because I still want the date to display in the same column but I only want it to display the last 3 transactions dates for each item and customer.
Do you have any more insight into this request? I need this to display only the last 3 TXNDATE per Item/Customer. I only want the date displayed in one column. I've been trying to get answers to this for way too long. I'm new to QLIK so a step by step answer would be helpful.