Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Champion III
Champion III

Re: Changing the order of values in a dimension

try this

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

Highlighted
Master II
Master II

Re: Changing the order of values in a dimension

Hi,

Try like below,

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

Highlighted
Master
Master

Re: Changing the order of values in a dimension

Hi Greg,

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

Highlighted
Creator
Creator

Re: Changing the order of values in a dimension

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.