topic Re: need expression in QlikView

need expression

Sat, 21 Sep 2013 16:47:48 GMT

Hi,

I need expression,suppose i have one order number as 100 and it is having multiple items as 'A' ,'B','C' and this multiple items have

multiple promise dates like

order item date

101 -A- 1-1-2013

B -2-2-2013

C -3-3-2013

now i want to show this particular order in max month

Re: need expression

CELAMBARASAN — Sat, 21 Sep 2013 18:14:38 GMT

Try with Date(Max(DateField))

Re: need expression

tresB — Sun, 22 Sep 2013 09:04:45 GMT

May be like this?

=Aggr(FirstSortedValue(item, -Month(date)),order)

assuming that you want to find the maxdate item

if you select an order, with this expression, you would get the max date item; if you have one dimension as order, then AGGR part would not be required.