Discussion Board for collaboration related to QlikView App Development.
I have Sample Data like below. But in real there will be multiple products
I need the Output like below
Go to Solution.
SET DateFormat='DD MMM YY';
(html, codepage is 1252, embedded labels, table is @1);
Date(Max(Date)) as Date,
FirstSortedValue(Value, -Date) as [Latest Product Value]
Group By Product;
View solution in original post
Expression: =FirstSortedValue(Value, -Date)
one more way
If your Date is in Text Format then use Date# like below else no need.
Load date(date#(Date,'DD MMM YY'),'DD MMM YY') as Date
left join (Data)
Load Date(max(Date),'DD MMM YY') as Date,
1 as LatestProductValueFlag
Load Product,sum(Value) as [Latest Product Value]
one more sample