Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

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

 

 

Labels (1)
3 Replies
Highlighted
Creator II
Creator II

Hi,

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

Highlighted
Partner
Partner

Hi there,

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

Highlighted
Creator II
Creator II

Can you share sample data?