topic Re: If then else expression in QlikView

If then else expression

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Could someone please help to give me some guidance on how to create an if, then else expression.

I need an expression for the following:

If Priority = 1 or 2 and Initial response is <= 10 min then 1, else if Priority = 3 or 4 or 5 and initial response <= 4 hours then 1 else 0.

Appreciate your help with this.

alexpanjhc — Tue, 13 Dec 2016 21:33:34 GMT

If ((Priority = 1 or Priority= 2) and [Initial response] <= 10 , 1,

if ((Priority = 3 or Priority= 4 or Priority= 5) and [initial response] <= 240, 1 , 0))

Wed, 14 Dec 2016 05:43:42 GMT

Thanks this works!