Discussion board where members can get started with QlikView.
i have a table with various fields, i want to only show the latest date by product and account name.
so an example would be..
so for the above, i would want to jide all of the rows that are highlighted and only show the other rows as they are the latest date.
can anyone help?
Go to Solution.
you can try below for chart
=if(Date = max(TOTAL <Account> Date),Date)
in Load Script
(biff, embedded labels, table is Sheet1$);
Max(Date) as Date
(biff, embedded labels, table is Sheet1$)
Group by Account;
Drop table MaxDate;
Please go through this
how to get last record??
How to get latest data | Qlik Community
Hi, i want to do this in a chart if possible, not script.
do you want to do that in the load script? or chart?
Если (Date = Max (TOTAL Дата), дата) (смотрите прикрепленный файл).
Only in your image date, highlighted in yellow, is not the last one. In the attached file I gave two tables - for MIN and MAX.
Thanks i used the chart expression!