How to sort accordingly ?

[suvechha_b]

Hi All ,

How can I sort the pivot table according to dimension. Please see the screen shot- My expected result should like

With most Saleable Stock will appear first and so on :-

W10 ,then W30 and then others.

sample model attached.

[malini_qlikview · Accepted solution]

Hi,

In chart properties --> Sort -- > disable any sort order for the Dimensions - Brand,Product,distributor_link

                                        --> Enable sort by Expression for dimension -Warehouse code name

set the sort by expression - descending and include the expression which you have for 'Salable Stock'

i.e : sum({1}{<distributor = {'NRP','Pin'}>} qty_available)- sum({1}{<distributor = {'NRP','Pin'},[Fiscal_Year]=,[Month]=>}stock_alloc_inv)

Modified sample app attached