topic Re: how to in QlikView

how to

Fri, 11 Sep 2015 06:12:37 GMT

Hi All,

and thank you very much for your help!!!

I have another problem to be solved...

TEST:

LOAD "ASSET_STATUS",

...

in the List Box returns the 0,1,3, ... values

how to assign

0, 'Ordered',

1, 'Received',

3, 'Deployed',

etc...

TEST:

"ASSET_STATUS",
if("ASSET_STATUS"=0, "ASSET_STATUS"='Ordered'),if("ASSET_STATUS"=1, "ASSET_STATUS"='Received'),
if("ASSET_STATUS"=3, 'Deployed'))), as "ASSET_STATUS", ................................. is not working

Re: how to

sunny_talwar — Fri, 11 Sep 2015 06:15:57 GMT

Try this:

Pick(Match("ASSET_STATUS", 0, 1, 3), 'Ordered', 'Received', 'Deployed') as "ASSET_STATUS_DESCRIPTION"

Re: how to

gautik92 — Fri, 11 Sep 2015 06:15:59 GMT

if("ASSET_STATUS"=0, 'Ordered',if("ASSET_STATUS"=1, 'Received'),
if("ASSET_STATUS"=3, 'Deployed')), as "ASSET_STATUS",

Re: how to

sasiparupudi1 — Fri, 11 Sep 2015 06:16:46 GMT

use apply map

map:

mapping load * inline

[

ASSET_STATUS,ASSET_DESC

0, 'Ordered',

1, 'Received',

3, 'Deployed',

];

TEST:

LOAD "ASSET_STATUS",applymap('map',ASSET_STATUS,'NA') as ASSET_STATUS_DEC;

hth

Sasi

Re: how to

sunny_talwar — Fri, 11 Sep 2015 06:23:39 GMT

If the list of "ASSET_STATUS" is large, I would use the method prescribed by Sasi (ApplyMap). If the list is small, I would use Pick(Match(...)...)

Re: how to

Fri, 11 Sep 2015 06:32:16 GMT

the "ASSET_STATUS" list contains 13 "ASSET_DESCRIPTION"

Re: how to

sunny_talwar — Fri, 11 Sep 2015 06:37:57 GMT

I think it would be safer and convenient to use ApplyMap which will give you the flexibility to make changes in the future. You can use Inline LOAD or Excel LOAD for the mapping table. Excel LOAD will make future changes easier to maintain.

Re: how to

kamalqlik — Fri, 11 Sep 2015 07:03:50 GMT

Hi Viorel,

Use the attached application to maintain your target.

You can use the Inline table or Excel for status and than map it with your transaction table to achieve the result.

Regards,

Kamal