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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sort in Expression

I have used this expression before to sort the display order on a graph before.

Why does it not sort in the order?

This is in the Expression 

=Dual([I feel I can trust my manager.],match([I feel I can trust my manager.],'Strongly Agree','Agree','Neutral','Disagree','Strongly Disagree'))

 

3 Replies
arockiyaselvana
Partner - Creator
Partner - Creator

Hi Robert,

Its not matching maybe  because of some spelling mismatches between the field and match function values.

Can u pls share some sample data here.

In the mean time, you can try the below expression, if your dimension of the chart is [I feel I can trust my manager.],

Pick(match([I feel I can trust my manager.],'Strongly agree','Agree','Neutral','Disagree','Strongly Disagree'),1,2,3,4,5)

in Sort by Expression

sunny_talwar
MVP
MVP

You can sort using this may be

Match(Only({1} [I feel I can trust my manager.]),'Strongly Agree','Agree','Neutral','Disagree','Strongly Disagree')

sasiparupudi1
Master III
Master III

Try Using Num([I feel I can trust my manager.])