topic Re: Requirement on Sorting in QlikView

Requirement on Sorting

Wed, 25 Nov 2020 16:16:04 GMT

Hi friends

i have to arrange the field values in This below order. and always zeros and null values should be in the bottom only.

Note: when we double click on Field then only field values changes from Ascending to Descending and Descending to Ascending order

Ascending:

.500

Descending:

500

499

Thanks,

Siddik

Re: Requirement on Sorting

sunny_talwar — Mon, 09 May 2016 19:26:00 GMT

Which object is this are we talking about?

Re: Requirement on Sorting

stevedark — Mon, 09 May 2016 19:37:54 GMT

Hi Abubakar,

As far as I am aware there is no way to find out whether the sort order on a column is Ascending or Descending at any given time. This would be useful for putting together a sort expression.

What may work is a sort expression that turns zeros into nulls, as nulls always reside at the bottom of the sort order.

The required expression would be something like:

=if(FieldName = 0, null(), FieldName)

This needs to go in the Expression box on the Sort tab, with the tick box next to it checked. Replace 'FieldName' with the name of the field you have in that column.

Hope that helps.

Steve

Re: Requirement on Sorting

Mon, 09 May 2016 19:54:02 GMT

Straight table

Re: Requirement on Sorting

Mon, 09 May 2016 19:55:15 GMT

Hi Steve Dark

I Have tried this expression but it is not working.

Re: Requirement on Sorting

Mon, 09 May 2016 20:00:26 GMT

sorry Steve Dark.now it is working

Thanks

Siddiq

Re: Requirement on Sorting

sunny_talwar — Mon, 09 May 2016 20:11:53 GMT

Please close this thread by marking Steve's answer as correct.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

Re: Requirement on Sorting

stevedark — Mon, 09 May 2016 20:14:45 GMT

Excellent - thanks for the heads up.

Steve

Re: Requirement on Sorting

Mon, 09 May 2016 20:35:48 GMT

correct.