Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sorting order Problem

Hello all!

I have a problem in the sorting order. I am trying to sort the sales of my qv report fron the highest value to the lowest, fisrt by store, then by floor no, but at the end the the sales are sorted and by Vendor but i dont want that to happen! I am attaching the qv file

Thank you very much in advance!!

10 Replies
muthukumar77
Partner - Creator III
Partner - Creator III

Hi,

Is Sales column Number field?

can you send me sample data?

Muthukumar Pandiyan
sunny_talwar

What is the sort order you are looking to get?

engishfaque
Specialist III
Specialist III

Dear Kyparisia,

Your Sales field must be at the top of other fields in Sort tab after that apply your sort order.

Here is the way please follow

1. Right Click on your Object > Properties > Tab "Sort" > Sort Priority > Select Your Field > Click on Button "Promote" until or unless your field does not reach at the top of other fields > Mark/checked Checkbox and select Ascending/Descending value from Drop Down box in "Sort by" section > Apply > OK.

Kind regards,

Ishfaque Ahmed

Anonymous
Not applicable
Author

Anonymous
Not applicable
Author

 

 

Anonymous
Not applicable
Author

Goodmorning Sunny!

First i want to be sorted by Store name, then by Floor no from lowest to highest and then by Sales (desending order).

As you can see in my qv example_1 the Vendor has nothing marked but it still affect my Sales. I want to be sorted from the highest value to lowest and only the floor no to affect them.

Thank you very mnuch for your help!

Anonymous
Not applicable
Author

Good morning!

Yes sales are number. I am attching the qv report.

Thank you very much in advance!

engishfaque
Specialist III
Specialist III

Dear Kyparisia,

Kindly find attached file. I hope you are looking for that one.

Kind regards,

Ishfaque Ahmed

Anonymous
Not applicable
Author

But as you can see in the attacment you send me the Sales are not sorted from highest to lowest value...