Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

Need custom sort in list box

Hi, I need help in sorting the values in list box alphabetically.

But the problem is , we have NA and N/V in our data and we need to keep these two specific values at very last and not in between the data in list box.

Is there any way to get this type of custom sort.

Please help me.

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Need custom sort in list box

Hi,

Go to Properties -> Sort Tab -> Write the expression for sorting as below.

If(Fieldname = 'NA' or Fieldname = 'N/V',1,2)

And then keep the sorting as ascending.

Also select the Text sorting.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

4 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Need custom sort in list box

Hi,

Go to Properties -> Sort Tab -> Write the expression for sorting as below.

If(Fieldname = 'NA' or Fieldname = 'N/V',1,2)

And then keep the sorting as ascending.

Also select the Text sorting.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

Highlighted
MVP
MVP

Re: Need custom sort in list box

-wildmatch(dim1, 'NA', 'N/V', '*')

replace dim1 with your field

1.png

Highlighted
Esteemed Contributor III

Re: Need custom sort in list box

try in sort tab expression

=match(fieldname.'Value1','value2')

Highlighted
Contributor

Re: Need custom sort in list box

Hi, Thanks for the help. I tried both the answers and both are working fine.

Thanks for your help.