topic Re: Case with when in load in qlikview in QlikView

Case with when in load in qlikview

vikasmahajan — Thu, 06 Aug 2015 07:17:10 GMT

Dear all,

I want to load following statement in Qlikview

Field1= Case

When DLT = 'ABC' then PQR

When DLT = 'CCC' then PQR

When DLT = 'DDD' then DDD

End

Field2 ...

Regards

Vikas

jonathandienst — Thu, 06 Aug 2015 07:21:36 GMT

Pick(Match(DLT, 'ABC', 'CCC', 'DDD'), 'PQR', 'PQR, 'DDD') As Field1

Anonymous — Thu, 06 Aug 2015 07:24:11 GMT

load

...

if (DLT='ABC' or DLT='CCC', 'PQR', DLT) as Field1,

if you have always different values to compare

load

if (DLT='ABC', 'PQR',

if (DLT='CCC', 'PQR',

if (DLT='DDD', 'DDD',

if (DLT=..., as Field1

vikasmahajan — Thu, 06 Aug 2015 07:31:47 GMT

Thanks

Works

Vikas

rubenmarin — Thu, 06 Aug 2015 07:35:42 GMT

Also you can maintain a table of correspondece and use applymap

Map_correspondece:

Mapping LOAD * Inline [

Key, Value

ABC, PQR

CCC, PQR

DDD, DDD

];

LOAD ApplyMap('Map_correspondece', DLT, [value_if_not_found]) as Field1

...

The Map_correspondence table can be loaded from any source allowing maintenance outside QV script.