Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
kashjaniqlik
New 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

Re: Custom Sorting - Amounts

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.