topic Load a field into different fields conditional on another field value in QlikView

Load a field into different fields conditional on another field value

Wed, 25 Aug 2010 00:41:44 GMT

I have 1 field to load into 2 possible fields based on the value of another field. Source field is f1, output fields are out1, out2, conditional field is c1. Here's what I'd like to happen:

If c1 = 1, load f1 as out1, load f1 as out2

if c1 = 2, load f1 as out1

if c1 = 3, load f1 as out2

if c1 =4, load f1 as out2

I tried using a pick statement like this:

if(c1=1,f1) as out1,

[f1] as pick(c1, 'out1','out1','out2','out2')

but the pick statement breaks.

Any thoughts?

Load a field into different fields conditional on another field value

johnw — Wed, 25 Aug 2010 00:55:31 GMT

if(match(c1,1,2),f1) as out1,
if(match(c1,1,3,4),f1) as out2,

Load a field into different fields conditional on another field value

rwunderlich — Wed, 25 Aug 2010 00:58:53 GMT

You can't use a conditional for the fieldname. Every row will have both an out1 and an out2. Your conditional will be for the value of those fields.

if( match(c1, '1', '2'), f1, '') as out1,

if( match(c1, '1', '3', '4'), f1, '') as out2

I think that's the right idea.

-Rob

Load a field into different fields conditional on another field value

Wed, 25 Aug 2010 18:22:37 GMT

Thx - works perfectly.