topic Re: Condition If in QlikView

Condition If

Wed, 11 May 2016 09:32:58 GMT

hello

I have a problem with if condition when i insert a formula,

this is my script

= if(interval([OV_DATA_CONS_RICH-OV_DATA_BOLLA],<-5),'Ritardo',

if(interval([OV_DATA_CONS_RICH-OV_DATA_BOLLA],>=-5),'Puntuale',

if(interval([OV_DATA_CONS_RICH-OV_DATA_BOLLA],''),'Non Consegnato')))

thanks in advance

Re: Condition If

ramoncova06 — Wed, 11 May 2016 17:28:14 GMT

try with this

= if(interval([OV_DATA_CONS_RICH-OV_DATA_BOLLA]),<-5,'Ritardo',

if(interval([OV_DATA_CONS_RICH-OV_DATA_BOLLA]),>=-5,'Puntuale',

if(interval([OV_DATA_CONS_RICH-OV_DATA_BOLLA]),'','Non Consegnato')))

you had the condition evaluation as part of the interval function

Re: Condition If

Chanty4u — Thu, 12 May 2016 04:55:26 GMT

try this

= if(interval([OV_DATA_CONS_RICH-OV_DATA_BOLLA])<-5,'Ritardo',

if(interval([OV_DATA_CONS_RICH-OV_DATA_BOLLA])>=-5,'Puntuale',

if(interval([OV_DATA_CONS_RICH-OV_DATA_BOLLA]),'Non Consegnato')))

Re: Condition If

jonathandienst — Thu, 12 May 2016 05:25:28 GMT

The use of interval here is redundant, It is a formatting function only and does not affect the calculations. What you require is not entirely clear due to the syntax errors in your expression, but perhaps you need this:

= if([OV_DATA_CONS_RICH-OV_DATA_BOLLA] < -5,'Ritardo',

if([OV_DATA_CONS_RICH-OV_DATA_BOLLA] >= -5,'Puntuale','Non Consegnato'))

Re: Condition If

jagan — Thu, 12 May 2016 05:37:28 GMT

Hi,

Check this

= if([OV_DATA_CONS_RICH-OV_DATA_BOLLA]<-5,'Ritardo',

if([OV_DATA_CONS_RICH-OV_DATA_BOLLA]>=-5,'Puntuale',

'Non Consegnato'))

Regards,

Jagan.

Re: Condition If

Kushal_Chawda — Thu, 12 May 2016 05:38:23 GMT

what you want to achieve? can you explain the logic?

Re: Condition If

Thu, 12 May 2016 13:22:14 GMT

i found the solution in this way:

=if(OV_DATA_CONS_RICH-OV_DATA_BOLLA<<0, 'Ritardo',if(OV_DATA_CONS_RICH- OV_DATA_BOLLA>>0,'Puntuale','Non Consegnato'))

the problem was that it read the second incorrectly condition

thank you all