topic Re: Is it possible to create Pick and Match expression for a date range? (As an alternative to IF statements) in QlikView

Is it possible to create Pick and Match expression for a date range? (As an alternative to IF statements)

jblomqvist — Mon, 12 Sep 2016 16:59:30 GMT

Hi all,

Is it possible to create a pick and match expression that is an alternative to a nested IF statement for different date ranges?

Example:

Let's say you had a DeliveryDate field.

And I wanted to create a criteria like this:

If DeliveryDate is less than <=5 days from OrderDate then it's Good

If DeliveryDate is between >=6 and <=10 days then it was Satisfactory

If Delivery Date is >=11 days then it is Late.

How can I write this in a Pick Match expression, if at all?

Re: Is it possible to create Pick and Match expression for a date range? (As an alternative to IF statements)

sunny_talwar — Mon, 12 Sep 2016 17:01:22 GMT

Just saw this thread today where somebody figured out a way to use Pick(Match()) instead of if for range

Pick Match with ‘greater/less than’ operators

Re: Is it possible to create Pick and Match expression for a date range? (As an alternative to IF statements)

MarcoWedel — Tue, 13 Sep 2016 00:15:47 GMT

Hi,

maybe one solution could be:

Pick(Match(-1,DeliveryDate-OrderDate<=5,DeliveryDate-OrderDate>=6 and DeliveryDate-OrderDate<=10,DeliveryDate-OrderDate>=11),'Good','Satisfactory','Late')

hope this helps

regards

Marco