Discussion Board for collaboration on QlikView Layout & Visualizations.
i need to sort my results in pivot table according to the expression calculated.. please have a look in the table given below.. i want to sort it out according to the Total Qty in descending order from top to bottom..
Please help me out to solve this problem..
Please add your experience to solve this problem.
As i understand you want to sort the chart by Total Qty Field, you need to set sort order in
Chart Properties -> Sort -> CheckMark Expression -> Select descending order from list and in below window type Total Qty Expression what ever it is and apply the conditon.
Hope this helps you
Thanks for your reply, I made changes according to your suggestion. but it is working please find the attached screenshot
You need to disselect other Dimension if it is selected in sort tab.