Making multiple field calculation into one same field

remo0017 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

I have a situation where i need to bring in all calculated if conditions into one single same field. Please help me to get this logic correct to the field T1 will have (B1, B2, B3) as its result set for the below conditions.

if ((field1='A1' and field2='B1'), B1) as T1

if ((field1='A2' and field2='B2'), B2) as T1

if ((field1='A3' and field2='B3'), B3) as T1

Result set:

T1: B1, B2, B3.

Thanks very much,

Re: Making multiple field calculation into one same field

YoussefBelloum — Fri, 26 Jan 2018 16:38:27 GMT

try this:

if((field1='A1' and field2='B1'), 'B1', if((field1='A2' and field2='B2'), 'B2', if((field1='A3' and field2='B3'), 'B3'))) as T1

topic Re: Making multiple field calculation into one same field in QlikView

Making multiple field calculation into one same field

Re: Making multiple field calculation into one same field