topic Re: Oldest Outstanding order in QlikView

Oldest Outstanding order

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

I can report on my outstanding order with no problem, but i am struggling with reports the oldest outstanding order only. Can anyone help?

Thanks

Chris

Clever_Anjos — Fri, 11 Aug 2017 10:55:13 GMT

Which criteria you use to classify an order as "outstanding"?

tresB — Fri, 11 Aug 2017 10:55:14 GMT

You may probably use firstsortedvalue() for the same. We could better help if you could provide a sample data set and explain the expected output.

ccsimo16 — Fri, 11 Aug 2017 10:57:57 GMT

I use express =if outstanding >0, sum(outstanding),'')

this will display all my outstanding

thanks

Chris

Chanty4u — Fri, 11 Aug 2017 10:59:01 GMT

i think u can use Firstsortedvalue(field,-dim)

if you want fixed values you can define the range

Firstsortedvalue(field,-dim,3)

Clever_Anjos — Fri, 11 Aug 2017 11:02:36 GMT

Maybe this, please adjust your field names

FirstSortedValue({<outstanding={">0"}>}OrderNum,Date)

ccsimo16 — Fri, 11 Aug 2017 11:32:35 GMT

Thank you to everyone, what a great community