Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
msawyercke
Creator
Creator

renaming values

Hi,

I have a variable in my data called "Bus. Unit".  There are 3 values business units - 10, 50 and 22.  The variable is part of a larger spreadsheet that loads via data load editor.

I use this field as a selection filter in one of my Sense sheets, but would like to change the business unit values to more meaningful descriptor in the actual filter display, such as:

10 = 'apples'

50 = 'oranges'

20 = 'grapefruit'

How do I accomplish this?  Do I add a command into the data load editor, or someplace else?  What function do I use?

Thanks for your help!!!!!!


Mike

10 Replies
msawyercke
Creator
Creator
Author

It works - thanks, SUNNY!!!!  You rock!!