Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Partner
Partner

help with showing latest data

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

Capture.JPG

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

1 Solution

Accepted Solutions
vinieme12
Esteemed Contributor II

Re: help with showing latest data

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;

6 Replies
prma7799
Honored Contributor III

Re: help with showing latest data

Partner
Partner

Re: help with showing latest data

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

Thanks

vinieme12
Esteemed Contributor II

Re: help with showing latest data

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

vinieme12
Esteemed Contributor II

Re: help with showing latest data

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
Honored Contributor

Re: help with showing latest data

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

Partner
Partner

Re: help with showing latest data

Thanks i used the chart expression!