Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Finsding status from higer timestamp

Hi

This might be a quite a simple expression for the people here , i am trying to find the status of the each request , with higher time stamp , attached my application , can some one help me in figuring the mistake i am making in my expression.

Thanks!

4 Replies
Not applicable

Re: Finsding status from higer timestamp

Hey,

You just needed to convert the timestamp into a human-readable format to compare with Status Date:

only({$<[Status Date]={'$(=(Timestamp(max([Status Date]))))'}>} srsh_status)

Hope this helps!

Not applicable

Finsding status from higer timestamp

for some reason the above expression did not work , i used below and it worked ..

only(if(srsh_status_dt=aggr(nodistinct max(srsh_status_dt),SR_ID),srsh_status))

Not applicable

Finsding status from higer timestamp

Hi

I suggest a more simple way, use FirstSortedValue

In you case create a chart with

Dimension :   Stocket Request #

Expression :  FirstSortedValue( srsh_status ,-[Status Date])   I use '-' to find the higher date

Regards

JJ

Not applicable

Finsding status from higer timestamp

this should help

aggr(FirstSortedValue(srsh_status,  - [Status Date]), [Socket Request #])

Community Browser