topic Re: Last 3 sales dates by item per customer in Search the Community

Last 3 sales dates by item per customer

EmpireDist — Tue, 16 Feb 2021 21:59:54 GMT

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.

Re: Last 3 sales dates by item per customer

Saravanan_Desingh — Wed, 17 Feb 2021 20:23:00 GMT

Try using Rank function. If you could not, please post a sample file with expected output

Re: Last 3 sales dates by item per customer

EmpireDist — Wed, 17 Feb 2021 21:58:14 GMT

I need it to display only the last 3 sales transactions per customer per item.

Re: Last 3 sales dates by item per customer

EmpireDist — Wed, 17 Feb 2021 22:23:17 GMT

I can not get a sample file to load

Re: Last 3 sales dates by item per customer

EmpireDist — Wed, 17 Feb 2021 23:50:39 GMT

This is a sample report. I want to display only the last 3 sales transactions for each item per customer.

Re: Last 3 sales dates by item per customer

Saravanan_Desingh — Thu, 18 Feb 2021 01:00:56 GMT

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;

Re: Last 3 sales dates by item per customer

Saravanan_Desingh — Thu, 18 Feb 2021 01:01:43 GMT

You can use any Field in the place of Date here:

Re: Last 3 sales dates by item per customer

EmpireDist — Thu, 18 Feb 2021 15:34:33 GMT

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

Re: Last 3 sales dates by item per customer

EmpireDist — Wed, 24 Feb 2021 23:05:27 GMT

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.

Re: Last 3 sales dates by item per customer

EmpireDist — Thu, 18 Mar 2021 14:56:38 GMT

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.