Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
undergrinder
Specialist II
Specialist II

Problem with Sorting

Hi All,

I have a problem with sorting order at tables with drill down dimension in Qlik Sense.

I have two columns in a table, and the sorting order is based on a 3rd column, which contains rank values.

The "Sort by expression" option with the 3rd column works only at top level of drill down,

the values are sorted by alphabetic at lower level.

I'll try to upload an example later.

Thanks!

G.

1 Solution

Accepted Solutions
reddy-s
Master II
Master II

Hi ,

You have a option for sorting it by level in the properties panel check this out.

Took your example and worked perfectly.

Untitled.png

Hope this solves your issue

Thanks,

Sangram

View solution in original post

6 Replies
undergrinder
Specialist II
Specialist II
Author

Here is the example:

Sorting_order.qvf

reddy-s
Master II
Master II

Hi,

I am trying to download your sample but it says that I have no authorization to do so.

I would suggest you to change the sort condition of all the dimensions and measures in the table to sort by expression and add the rank field. This will help solve your issue.

undergrinder
Specialist II
Specialist II
Author

Hi Sangram,

I'll try it.

Sorting_order.qvf

G.

reddy-s
Master II
Master II

Hi ,

You have a option for sorting it by level in the properties panel check this out.

Took your example and worked perfectly.

Untitled.png

Hope this solves your issue

Thanks,

Sangram

undergrinder
Specialist II
Specialist II
Author

Hi Sangram,

Thank you very much, I haven't noticed that option yet.

It works!

G.

reddy-s
Master II
Master II

Always Welcome!