topic Re: Problem with Sorting in App Development

Problem with Sorting

undergrinder — Mon, 11 Jan 2016 15:49:59 GMT

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!

Re: Problem with Sorting

undergrinder — Mon, 11 Jan 2016 20:06:39 GMT

Here is the example:

Sorting_order.qvf

Re: Problem with Sorting

reddy-s — Tue, 12 Jan 2016 18:52:58 GMT

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.

Re: Problem with Sorting

undergrinder — Wed, 13 Jan 2016 08:22:50 GMT

Hi Sangram,

I'll try it.

Sorting_order.qvf

Re: Problem with Sorting

reddy-s — Wed, 13 Jan 2016 11:06:35 GMT

Hi ,

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

Took your example and worked perfectly.

Hope this solves your issue

Thanks,

Sangram

Re: Problem with Sorting

undergrinder — Wed, 13 Jan 2016 13:10:42 GMT

Hi Sangram,

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

It works!

Re: Problem with Sorting

reddy-s — Wed, 13 Jan 2016 13:55:47 GMT

Always Welcome!