How to get ID and Name using Latest availavle date using Qlikview script(Please find attachment)

[grakeshqvd]

ID	Name	Status	Date
101	PLAN	Hold	5/16/2019
101	PLAN	No Issue	5/9/2029
102	Approval	Resolved	5/9/2019
102	Approval	Hold	5/16/2019
103	Scope	Hold	5/19/2019
103	Scope	Resolved	5/16/2019

ID	Name	Status	Date
101	PLAN	Hold	5/16/2019
102	Approval	Hold	5/16/2019
103	Scope	Hold	5/19/2019

[tresesco]

If you are looking for 'hold' only information, try like:

Dim 1 : ID

Dim 2 : Name

Dim 3 : If(Status= 'Hold', Status)

Exp : Date(Max(Date))

And, enable 'Suppress When Value Is Null' for third calculated dimension 

[PrashantSangle]

where you want to achieve it in front end or back end??

in back end
Load * from tableName
where status='Hold';

in front end
take
Dimension : ID, Name, Status
Expression : Date(Max({<Status={'Hold'}>}Date))

[Frank_Hartmann]

If you are looking for the max Date per ID then try following code:

tmp0:
LOAD Status,
Name,
ID,
Date
FROM
[https://community.qlik.com/t5/New-to-QlikView/How-to-get-ID-and-Name-using-Latest-availavle-date-usi...]
(html, codepage is 1252, embedded labels, table is @1);

left join
Load ID,max(Date) as Date, FirstSortedValue(Name,-Date) as Data Resident tmp0 Group by ID;

NoConcatenate

Final:
Load * Resident tmp0 Where Data<>Null();DROP table tmp0; DROP Field Data;

[grakeshqvd]

Hi prasanth,

We need it Back end script side only.

Actually, we have already one filed having all the values like for example...

IF(Token='Review' AND DATE(Datefield,'M/D/YYYY')>DATE(Startdate,'M/D/YYYY'),'Review Item',

IF(Type='Release','Release Type')) As Required.

We need to include that value in the "Required" field.

currently, Required field having values (Review Item and Release Type) same like we need add MaxDate(ID and Name) Value in to Required Field like I have attached document.

[PrashantSangle]

Sorry i did not get you. can you share sample data with expected output.

the logic which I have share, will work as per earlier sample data. If it is not satisfying your requirement then share sample data as per format which you have now.

regards,

Prashant Sangle

[grakeshqvd]

Hi Prasanth,

Please find attached.

Regards,

Rakesh

[Brett_Bleess]

I suspect what the guys wanted here was a sample qvw file, not the Word Doc, so if you can attach that, they may get back to you on things.

Regards,
Brett