topic Re: custom sort in list box in QlikView

custom sort in list box

everest226 — Wed, 25 Nov 2020 16:16:04 GMT

hi i have list box (Name) , there is a value , in ascending like , Alex , Bam, Cat, NO name, sdd, hjsgdh ,,zzz,, etc

I want to show no name on top .

Anil_Babu_Samineni — Thu, 30 Nov 2017 14:52:52 GMT

May be use descending number

surendraj — Thu, 30 Nov 2017 14:53:39 GMT

do u want to remove caption?

vvvvvvizard — Thu, 30 Nov 2017 14:53:41 GMT

maybe sort by expressing , ascending , if(Match(Name,'NO Name, 'Alex','Bam','Cat')

everest226 — Thu, 30 Nov 2017 14:54:12 GMT

wont work because i have some name that comes after n also

surendraj — Thu, 30 Nov 2017 14:55:05 GMT

Properties-->Sort-->text-->Z-A

everest226 — Thu, 30 Nov 2017 14:56:34 GMT

wont work some names are after no names also. just want no name at y top then ascending order

Anil_Babu_Samineni — Thu, 30 Nov 2017 14:56:43 GMT

Not sure, How many values under this field. And ext. could be use Sort by expression with Match(FieldName, 1,2,3,4)

Here - 1,2,3,4 are the values you want to sort If values has less rows

surendraj — Thu, 30 Nov 2017 14:58:02 GMT

Go with Yusuuf Answer!!it works by custom sort only.

trdandamudi — Thu, 30 Nov 2017 15:20:55 GMT

One way to do this is as below:

Expression:
=Pick(Match(Name, 'NO name')+1, Name ,'NO name')

Sort Expression:

=Pick(Match(Name, 'NO name'),1,2)

Mark_Little — Thu, 30 Nov 2017 15:21:54 GMT

Hi,

Couple of options is look at the duel() function.

Or use an inline load to create a new field for sort order.

Then when you add the list box, in the sort field tick expressions and select your new field.

Mark