Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Changing the order of values in a dimension

I would like to change the order of values in a dimension.  I tried to use the following expression as my dimension and whilst they appeared in the correct order the values changes to '1', '2' and '3' rather than their normal names.

=Match([SSES_mode], 'Full-time', 'Part-time', 'Distance/Flexible')

Any suggestions?

Thanks

Greg

4 Replies
Chanty4u
MVP
MVP

try this

if(Match([SSES_mode], 'Full-time', 'Part-time', 'Distance/Flexible') ,[SSES_mode])

devarasu07
Master II
Master II

Hi,

Try like below,

=pick(Match([SSES_mode], 'Full-time', 'Part-time', 'Distance/Flexible'),1,2,3)

stabben23
Partner - Master
Partner - Master

Hi Greg,

what chart do you use? You can order Your Dimension in sort tab.

Anonymous
Not applicable
Author

I managed to get this to work eventually using the following expression as my dimension

=Dual(Pick(Match(SSES_mode, 'Full-time', 'Part-time', 'Distance/Flexible'),
'Full-time', 'Part-time', 'Distance/Flexible'),
Match(SSES_mode, 'Full-time', 'Part-time', 'Distance/Flexible')) 

Thanks for your help.