topic Re: Max Function in QlikView

Max Function

Anonymous — Tue, 17 Jun 2014 19:01:44 GMT

Hello,

In an expression, I am trying to determine whether a SKU is Import or Domestic with the field, [PO Imp/Dom] which will give me either "I" or "D" for the last [PO Entry Date]. I would like to know how to determine whether or not a SKU is an "I" or a "D" based on the max [PO Entry Date].

Any help would be greatly appreciated!

Isabel

Re: Max Function

venkatg6759 — Tue, 17 Jun 2014 19:03:18 GMT

Use firstsorted value

Firstsortedvalue([PO Imp/Dom] ,-[PO Entry Date])

Re: Max Function

Anonymous — Tue, 17 Jun 2014 19:06:58 GMT

Thanks!

Re: Max Function

eduardo_sommer — Tue, 17 Jun 2014 19:07:38 GMT

Use this:

if(firstsortedvalue([PO Imp/Dom ], -[PO Entry Date])='I', 'Imported', 'Domestic')

Eduardo