Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Vegar
MVP
MVP

How to sort a listbox with dual values alphabetical?

I'm trying to sort my listbox values alphabetical by text value, but I'm not able to? (I'm sorry for the odd language in the gif animation below, but I think you get the point.)

Can you guys confirm this behaviour on your QlikView desktops? Do you have a workaround without changing the dual into a text in the data load?

How 2 sort a dual.gif

My desired output is 

  • aug.
  • dec.
  • feb.
  • jan.
  • juli
  • juni
  • maj
  • mars
  • nov.
  • okt
  • sep.

 

Im working in the November 2018 release.

Labels (4)
1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

Hi Vegar
 try using expression in the list box
i.e. text(Month)Capture.PNG

 

View solution in original post

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

Hi Vegar
 try using expression in the list box
i.e. text(Month)Capture.PNG

 

Vegar
MVP
MVP
Author

Your solution works like a charm.
I was afraid to get odd expression-like selections in my current selection box, but it behaves normal.