How to sort accordingly ?

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: How to sort accordingly ?

malini_qlikview — Mon, 10 Apr 2017 13:51:24 GMT

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