Discussion board where members can get started with QlikView.
I have a question. How can I find the newest record for a list of contacts? I have the following data
and so on...
CustA has brought 500 items over the last 6 years
CustB has brought 300 items over the last 6 years
CustC has brought 800 items over the last 6 years
The fields are
Customer, Transaction Date, Transaction Year, Item.
What I would like to find out is a list of the last transaction a customer has made so that I can see they are a current customer or a customer which used to buy from us but no longer does.
Thank you in advance for any help possible
Go to Solution.
Maybe like this:
Create a straight table chart with dimension Customer, then as expressions (whatever you want to display):
=FirstSortedValue(Item, -[Transaction Date])
I assumed that your Transaction Date has a numeric representation, like all dates created or interpreted correctly by QV.
Hope this helps,
You can probably use the firstsortedvalue. See here for two video tutorials explaning what the function does and how to use it.
Hello Gysbert Wassenaar,
Thank you for the link, Very helpful.
Perfect, thanks a lot. Your help is highly appreciated