Finding one Value of with Max Date

[#1]

Hi all

I have a straight table i need to pull only 1 value based on max date and project. suggest me

Script used to derive the data.

Trans3:
Load
ProjectID_SYS,
[Updated On],
[Value Before Update] as N_Customer_Traction_Status
Resident [Project Metrics History]
where [Metric Name]='Customer Traction Status';

Trans4:
load
ProjectID_SYS,
if([Metric Name]='Customer Traction Status',Timestamp(Max([Updated On]),'MM/DD/YYYY hh:mm:ss TT')) as Maxmetric
Group by ProjectID_SYS,[Metric Name];

[senpradip007]

Try like

Trans4:
load
ProjectID_SYS,
if([Metric Name]='Customer Traction Status',Timestamp(Max([Updated On]),'MM/DD/YYYY hh:mm:ss TT')) as Maxmetric

Resident [Project Metrics History]
where [Metric Name]='Customer Traction Status'
Group by ProjectID_SYS,[Metric Name];

[#3]

Thanks pradip,

but the result is still showing 2 values .

For check the actual table before the transformation used above with Trans3 and Trans4. the date is this way below.

[#4]

It is very usefull

[senpradip007]

Can you upload sample qvw ?

[#6]

Please find the attachment.

[qlikmsg4u]

try this

Trans4:

load

ProjectID_SYS,

if([Metric Name]='Customer Traction Status',Max(Timestamp#([Updated On],'MMM,DD YYYY'))) as Maxmetric

Resident [Project Metrics History]

where [Metric Name]='Customer Traction Status'

Group by ProjectID_SYS,[Metric Name];

[senpradip007]

Reload this attachment and let me know.

[qlikmsg4u]

Vamsi,

Find the attached one, Hope this will help to you

[#10]

Its not working Pradip