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: 
everest226
Creator III
Creator III

custom sort in list box

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 .

1 Solution

Accepted Solutions
trdandamudi
Master II
Master II

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)

View solution in original post

10 Replies
Anil_Babu_Samineni

May be use descending number

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
surendraj
Specialist
Specialist

do u want to remove caption?

vvvvvvizard
Partner - Specialist
Partner - Specialist

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

everest226
Creator III
Creator III
Author

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

surendraj
Specialist
Specialist

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

everest226
Creator III
Creator III
Author

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

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
surendraj
Specialist
Specialist

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

trdandamudi
Master II
Master II

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)