Discussion board where members can get started with QlikView.
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.
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.
View solution in original post
-wildmatch(dim1, 'NA', 'N/V', '*')
replace dim1 with your field
try in sort tab expression
Hi, Thanks for the help. I tried both the answers and both are working fine.
Thanks for your help.