topic Re: Showing incorrect status in QlikView

Showing incorrect status

Tue, 18 Jun 2013 08:15:14 GMT

Hi all,

I have a straight table, which show a status relating to an Order.

I'd like to just show the most up-to-date Action Status per order, but in my case it isn't reflecting this.

I've used an aggr expression to get the latest Creation Timestamp, which seems to work just fine. But using the Action Status as a dimension, it doesn't return

the latest Action Status???

I 've attached a sample .qvw of what I'm trying to achieve.

If you have any ideas as to what I'm doing wrong or missing, I'd like to hear your thoughts.

Many thanks

Re: Showing incorrect status

tresB — Tue, 18 Jun 2013 11:22:45 GMT

Hello,

Your CreationTimeStamp is being read as TEXT that is why QV is not beaing able to understand the max/min. You have to correct that while it is beaing loaded. And then you can try FirstSortedValue function to achieve the same easily.

Thanks.

Re: Showing incorrect status

Tue, 18 Jun 2013 12:20:23 GMT

You may try attached application.....

Re: Showing incorrect status

Tue, 18 Jun 2013 12:27:32 GMT

you may also look at this one...which is built using firstSortedValue as an expression as guided by tresesco