Custom Sorting - Amounts

kashjaniqlik — Thu, 19 Oct 2017 15:13:32 GMT

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.

Re: Custom Sorting - Amounts

its_anandrjs — Thu, 19 Oct 2017 15:26:17 GMT

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.

topic Re: Custom Sorting - Amounts in QlikView

Custom Sorting - Amounts

Re: Custom Sorting - Amounts