topic If loop in Tabelle in QlikView

If loop in Tabelle

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hello everyone

I want to write an if loop in the script:

if there is no value in the second column "age" of the table below, the fifth column must be empty or #NULL! stay.

if (age=0 , DRG=#NULL!)

I'm not so sure if this previous condition is enough.

I would be grateful for any answer 🙂

MendyS — Mon, 31 Oct 2022 09:56:37 GMT

Hi @Anonymous

try to do that in the data load editor,
TeableName:

No Concatenate

Load *, if ( age>=0, fifthColumnName) As fifthColumnNameTemp

Resident ...

Drop Field fifthColumnName;

Rename fifthColumnNameTemp to fifthColumnName;

Anonymous — Mon, 31 Oct 2022 10:53:53 GMT

Thanks for the answer

I didn't mention that the screenshot is a script.

The goal is:
There is no need to write a value in DRG if there is no age.

It is not exactly about renaming, but about change the value in #NULL!.

MendyS — Mon, 31 Oct 2022 12:23:03 GMT

@Anonymous

yes, I know.

what I write gives you null if there is no value in the age field (if the age is small from 0, the field returns Null).