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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ferdie
Partner - Contributor II
Partner - Contributor II

How to order table field after a specific value?

I recently added an ▲ symbol before the numbers in my 'diff' column. Sorting, however, is not working properly right now. Is it possible for me to let the column ignore the ▲ symbol and just use the numbers after it for ordering it descending/ascending? I know it's possible to just add the ▲ after the numbers, but that looks all over the place if I'm dealing with different lengths of numbers, so I rather have it in front. 

Diff.PNG

Thanks already

 

 

3 Replies
mfarsln
Creator II
Creator II

Hi,

In the sorting options, set it to 'by expression'. Then sort it by your diff measure expression.

Ferdie
Partner - Contributor II
Partner - Contributor II
Author

Hi there,

I only have two options in the Sorting section:  Nurmeric or Alphabet sorting

mfarsln
Creator II
Creator II

Can you share sample data?