If clause with multiple fields

srikantj — Sat, 16 Nov 2024 00:35:31 GMT

Hi qlikss,

I have 2 fields.

A & B

A B

1 5

2 0

0 4

I want to create third column as comment

If A=0, A is zero if B=0, B is zero

Final table should look like this

A B comment

1 5

2 0 B is zero

0 4 A is zero.

Someone help me with code

Re: If clause with multiple fields

Taoufiq_Zarra — Wed, 17 Feb 2021 20:31:05 GMT

if(A=0 or B=0,'zero') as comment

load *,if(A=0 or B=0,'zero') as comment inline [
A,B
1,5
2,0
0,4
];

output: