Pivot table in QlikSense has no Y-Value sorting.
So you will need to use dual and aggr function to assign particular dimension with sortable numerical value.
Here is the details
I found a solution to this issue. It works most of the times I have used it, however there have been glitches so be cautious while using it.
In the pivot table, go to Sorting. For the dimension that you want sorted, select Sort by Expression. The Expression you write is:
RANK(The expression of the measure on which you want the dimension values to be sorted).