Sorting order of Pivot table

kmmqlick — Fri, 16 Sep 2022 02:18:37 GMT

Hi All,

Thanks for your reply in advance.

I am having issue with sorting order of Pivot table data. I am having Year wise sales data. Like this data i am having 40 lines of descriptions of different years. Discount % are changes every year, I want show same table. To maintain same order i taken Inline load. But that does not work . Suggest me how to show entire table in the same manner in qlik table

Descripton	Long Sales	Short Sales	Total Sales	Year
Total Asset Sales	500000	300000	800000	2020
Fixed Assets	300000	200000	500000	2020
Variable assets	200000	100000	300000	2020
Discounts	60000	50000	110000	2020
Holesale Discount(55%)	35000	30000	65000	2020
Vendor Discount(45%)	25000	20000	45000	2020
Total Sale	440000	250000	690000	2020

Descripton	Long Sales	Short Sales	Total Sales	Year
Total Asset Sales	800000	400000	1200000	2021
Fixed Assets	600000	300000	900000	2021
Variable assets	200000	100000	300000	2021
Discounts	40000	60000	100000	2021
Holesale Discount(70%)	30000	30000	60000	2021
Vendor Discount(30%)	10000	30000	40000	2021
Total Sale	760000	340000	1100000	2021

I taken Inline load

Load * Inline

[Order , Description

];

topic Sorting order of Pivot table in App Development

Sorting order of Pivot table