Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kashjaniqlik
Contributor III
Contributor III

Custom Sorting - Amounts

Hello

We have a chart with a dimension and an expression with amounts. The amount is split in to millions and actual values i.e. if the value > 1 million, the values will be shown in million and if it is less than 1 million it will show the actual value i.e. 839,192.

Example

Country   Amount

ABC         120 million

BCE         2 million

DEF          12,999

EFG         890,281

FGT         38 million

The problem we are facing is to set default and interactive sort. Is there we can have a custom sort so all above custom values are included in the sorting as below.

Country   Amount

ABC         120 million

FGT         38 million

BCE         2 million

EFG         890,281

DEF          12,999

Currently the sort is done by numbers and it ignores the million representation.

Thanks for your help.

1 Reply
its_anandrjs

I believe Amount is your metric expression if so use this expression in your sort in the sort properties >> write this expression and do select there ascending



Ex:-


=Sum(Sales) but in accending order.