topic Re: How to get ID and Name using Latest availavle date using Qlikview script(Please find attachment) in QlikView

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

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

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

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

tresB — Wed, 26 Jun 2019 06:49:01 GMT

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

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

PrashantSangle — Wed, 26 Jun 2019 06:50:48 GMT

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

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

Frank_Hartmann — Wed, 26 Jun 2019 07:02:40 GMT

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-using/td-p/1596006]
(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;

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

grakeshqvd — Wed, 26 Jun 2019 07:49:26 GMT

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.

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

PrashantSangle — Wed, 26 Jun 2019 10:54:10 GMT

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

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

grakeshqvd — Wed, 26 Jun 2019 11:27:16 GMT

Hi Prasanth,

Please find attached.

Regards,

Rakesh

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

Brett_Bleess — Tue, 23 Jul 2019 13:07:45 GMT

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