Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

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
Champion III
Champion III

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;

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

6 Replies
prma7799
Master III
Master III

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

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

Thanks

vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

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;

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
ahaahaaha
Partner - Master
Partner - Master

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
Partner - Specialist III
Partner - Specialist III
Author

Thanks i used the chart expression!