topic Re: simple if statement in QlikView

simple if statement

shehovsovi — Sat, 16 Nov 2024 03:24:22 GMT

Hello,

I'm new to qlikview.

I'm trying to write a simple if statement as part of the expression in a straight table. Keep getting errors:

I have two dates, which i subtracted from each other and the results are all over the place. I'm using if statement to normalize the results, to get values of 0,30,60,90,90+

if((CONTROL_DATE - PAID_THRU_DATE)<0,0,

IF(CONTROL_DATE - PAID_THRU_DATE)>90,'90+',

(CONTROL_DATE - PAID_THRU_DATE))

Qlikview only likes this part " if((CONTROL_DATE - PAID_THRU_DATE)" everything else is underscored in red.

Ideally wanted to create this normalized field as part of LOAD script but kept getting an error that field is not found.

I created a CONTROL_DATE field in the LOAD script and than tried using it in the same script and was getting the error that CONTROL_DATE does not exist.

Please help.

Thank you

Re: simple if statement

Lisa_P — Mon, 03 Jun 2019 22:49:32 GMT

Missing some brackets ....
if((CONTROL_DATE - PAID_THRU_DATE)<0,0,
IF((CONTROL_DATE - PAID_THRU_DATE)>90,'90+',
(CONTROL_DATE - PAID_THRU_DATE)))

Re: simple if statement

zzyjordan — Tue, 04 Jun 2019 04:25:40 GMT

Apart from missing brackets, need convert the output as text as well

if( (CONTROL_DATE - PAID_THRU_DATE)<0,'0',
IF( (CONTROL_DATE - PAID_THRU_DATE)>90,'90+',
Text(CONTROL_DATE - PAID_THRU_DATE)
)
)

Hope this helps
ZZ