topic Finsding status from higer timestamp in QlikView

Finsding status from higer timestamp

Tue, 20 Sep 2011 17:57:07 GMT

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!

Re: Finsding status from higer timestamp

Tue, 20 Sep 2011 18:36:16 GMT

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!

Finsding status from higer timestamp

Tue, 20 Sep 2011 18:43:38 GMT

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

Finsding status from higer timestamp

Tue, 20 Sep 2011 18:51:08 GMT

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

Finsding status from higer timestamp

Tue, 20 Sep 2011 19:24:04 GMT

this should help

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