Qlik Community

Qlik Sense App Development

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

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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?