topic Re: Need custom sort in list box in QlikView

Need custom sort in list box

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

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.

Re: Need custom sort in list box

kaushiknsolanki — Thu, 21 Sep 2017 11:50:02 GMT

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

Re: Need custom sort in list box

maxgro — Thu, 21 Sep 2017 11:57:51 GMT

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

replace dim1 with your field

Re: Need custom sort in list box

Chanty4u — Thu, 21 Sep 2017 12:16:37 GMT

try in sort tab expression

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

Re: Need custom sort in list box

musketeers — Thu, 21 Sep 2017 12:31:34 GMT

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

Thanks for your help.