Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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