topic Re: Problem with IF statement in Load in QlikView

Problem with IF statement in Load

Black_Hole — Sat, 16 Nov 2024 03:06:47 GMT

Hello all,

In my script, I write an IF statement and I save the result in a new column.

But I don't understand why after to run the script I get none value for the column created.

Below my script:

AMOUNT:
LOAD *,
IF(LEN(Type)=0,Credit,Debit) as test
RESIDENT JOURNAL;

Below the result:

Please could you help me to resolve this problem.

Thank you in advance for your help.

Re: Problem with IF statement in Load

neelamsaroha157 — Tue, 02 Jul 2019 18:16:09 GMT

Can you add a new column as LEN(Type) just to check the values you for the newly added column.

Re: Problem with IF statement in Load

Brett_Bleess — Tue, 30 Jul 2019 14:55:13 GMT

Only other thing that came to mind for me was if you aliased Type in the original load statement and are using the original field name not the alias? Highly unlikely, but I wanted to toss it out there just in case.

Regards,
Brett

Re: Problem with IF statement in Load

nicolas66 — Tue, 30 Jul 2019 15:26:17 GMT

Bonjour,

If(LEN('Type')=0, 'Credit', 'Debit') as test

... perhaps ?

Re: Problem with IF statement in Load

Berndtssono — Thu, 01 Aug 2019 11:38:35 GMT

if(len(Type)='0', Credit, Debit) as test

maybe like that