topic Re: help with showing latest data in QlikView

help with showing latest data

hopkinsc — Wed, 25 Nov 2020 16:16:04 GMT

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..

Re: help with showing latest data

prma7799 — Thu, 08 Jun 2017 12:01:23 GMT

Please go through this

how to get last record??

How to get latest data | Qlik Community

Re: help with showing latest data

hopkinsc — Thu, 08 Jun 2017 12:43:11 GMT

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

Thanks

Re: help with showing latest data

vinieme12 — Thu, 08 Jun 2017 12:46:08 GMT

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

Re: help with showing latest data

vinieme12 — Thu, 08 Jun 2017 12:51:44 GMT

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;

Re: help with showing latest data

ahaahaaha — Thu, 08 Jun 2017 13:14:13 GMT

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

Re: help with showing latest data

hopkinsc — Thu, 08 Jun 2017 13:44:09 GMT

Thanks i used the chart expression!