Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Certification Exam Sale - 40% off. Register by June 30, 2020. GET DETAILS
Contributor 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 .

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Honored Contributor II

Re: custom sort in list box

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
Highlighted

Re: custom sort in list box

May be use descending number

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)
Highlighted
Valued Contributor

Re: custom sort in list box

do u want to remove caption?

Highlighted
Contributor III

Re: custom sort in list box

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

Highlighted
Contributor III

Re: custom sort in list box

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

Highlighted
Valued Contributor

Re: custom sort in list box

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

Highlighted
Contributor III

Re: custom sort in list box

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

Highlighted

Re: custom sort in list box

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

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)
Highlighted
Valued Contributor

Re: custom sort in list box

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

Highlighted
Honored Contributor II

Re: custom sort in list box

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