topic Creating a label from a numeric value in QlikView

Creating a label from a numeric value

Wed, 25 Nov 2009 05:48:15 GMT

For specific data I need to translate a number to a label. I have been using an if() function like

if(MANAGER1=5304, 'End Users',
if(MANAGER1 =5569, 'IBM',
if(MANAGER1=5349, 'HP',
'All Others')))

In the example above I am simply summing the revenue by manager, but was to provide a label instead of the manager number used by the system. I was wondering if there was an easier way as this can get pretty long and difficult to manage.

Creating a label from a numeric value

rwunderlich — Wed, 25 Nov 2009 05:51:46 GMT

Use a MAPPING LOAD with either an applyMap() or MAP USING statement. See the Reference Guide section on Mapping.

-Rob

Creating a label from a numeric value

Wed, 25 Nov 2009 05:58:51 GMT

Thanks Rob! I just happened to run across the blog entry after I added the post.