help with showing latest data

[hopkinsc]

Hi All,

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?

example attached..

[prma7799]

Please go through this

how to get last record??

How to get latest data | Qlik Community

[hopkinsc]

Hi, i want to do this in a chart if possible, not script.

Thanks

[vinieme12]

do you want to do that in the load script? or chart?

[vinieme12 · Accepted solution]

you can try below for chart

=if(Date = max(TOTAL <Account> Date),Date)

in Load Script

data:

LOAD Account,

     City,

     Postcode,

     Name,

     T1,

     Product,

     [Group Outlet],

     [Image Type],

     Listed,

     Date

FROM

data.xls

(biff, embedded labels, table is Sheet1$);

Right Keep

MaxDate:

LOAD Account,

     Max(Date) as Date

FROM

data.xls

(biff, embedded labels, table is Sheet1$)

Group by Account;

Drop table MaxDate;

[ahaahaaha]

Hi,

Expression

Если (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.

Regards,

Andrey

[hopkinsc]

Thanks i used the chart expression!