Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sushil353
Honored Contributor II

How to sort data according to expression values

Hi All,

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..

TABLE.JPG

4 Replies
sushil353
Honored Contributor II

How to sort data according to expression values

Hi Experts,

Please add your experience to solve this problem.

Thanks

How to sort data according to expression values

Hi,

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

Regards,

Anand

sushil353
Honored Contributor II

How to sort data according to expression values

Hi Anand,

Thanks for your reply, I made changes according to your suggestion. but it is working please find the attached screenshot

table3.JPG

How to sort data according to expression values

Hi,

You need to disselect other Dimension if it is selected in sort tab.

Regards

Anand

Community Browser