topic Re: Create field based on other fields in QlikView

Create field based on other fields

Thu, 05 Sep 2013 11:39:00 GMT

Hei,

Is it possible to create a new field based on the value of other fields?

Basically i want to cross reference different fields and return some category.

if(field1 == "1" and field2=="2") Category = "C1"

else if(field3 == "test") Category = "c2"

else

Category = "C3" (all others)

Please don't hesitate to ask if i am being unclear.

Best Regards,

Lasse Rolstad

swuehl — Thu, 05 Sep 2013 11:47:18 GMT

LOAD

field1,

field2,

field3,

if(field1 = 1 and field2 = 2,'C1',

if(field3='test', 'c2',

'C3')) as Category,

...

Thu, 05 Sep 2013 12:04:54 GMT

Again you come to my rescue. Thanks alot