topic Re: Re: Sorting the values in a listbox when using an expression in the sort tab in QlikView

Sorting the values in a listbox when using an expression in the sort tab

Anonymous — Fri, 25 Apr 2014 09:23:23 GMT

I want to know if anyone knows how to sort the values in a listbox, when one is forced to have an expression in the sort tab?

I had to use the same expression from the general tab in the sort tab

if(datakilde='Aarlig', Aktivitetsnavn)

- otherwise the listbox didn't show the associated values (from a selected value from another listbox) in the top of the listbox - which aren't very user friendly.

But as a consequence the sorting in alphabetic order is no longer works...

See my sort tab below.

Kind Regards Maria

Re: Sorting the values in a listbox when using an expression in the sort tab

Gysbert_Wassenaar — Fri, 25 Apr 2014 11:06:30 GMT

It sometimes helps to set Sort by State to Ascending instead of Auto Ascending.

Re: Sorting the values in a listbox when using an expression in the sort tab

Anonymous — Fri, 25 Apr 2014 14:08:30 GMT

I already did that - but the result is the same.

Re: Sorting the values in a listbox when using an expression in the sort tab

Gysbert_Wassenaar — Fri, 25 Apr 2014 14:11:07 GMT

Can you post a qlikview document that demonstrates the problem? If you're worried about confidential data, please read this document first: Preparing examples for Upload - Reduction and Data Scrambling

Re: Re: Sorting the values in a listbox when using an expression in the sort tab

MarcoWedel — Sun, 27 Apr 2014 00:16:31 GMT

Hi maria,

did you use the sorting expression, when trying Gysbert's "Sort by State Ascending" suggestion?

without a sorting expression, just sorting by state ascending and text ascending seems to work:

whereas other settings show the behaviour, you described:

regards

Marco

Re: Sorting the values in a listbox when using an expression in the sort tab

Anonymous — Wed, 07 May 2014 06:39:13 GMT

I have now made my document ready to be posted in here.

Probably a stupid question, but how do I oploead the Qlikview document?

Re: Re: Sorting the values in a listbox when using an expression in the sort tab

MarcoWedel — Wed, 07 May 2014 09:09:15 GMT

in the editor window click "use advanced editor" in the upper right and then "attach" in the lower right corner.

regards

Marco

Re: Re: Re: Sorting the values in a listbox when using an expression in the sort tab

Anonymous — Wed, 07 May 2014 09:14:42 GMT

Ok, thanks. Here is my Qlikview document - I hope someone is able to help me sort the values in the listbox in the bottom - where one can search. I hope it is not inconvenient that I used the scramble option?

Re: Sorting the values in a listbox when using an expression in the sort tab

MarcoWedel — Wed, 07 May 2014 10:47:18 GMT

I don't see any sorting issues when using the sorting setting "state ascending" like Gysbert suggested:

Do you still expect any different behaviour?

regards

Marco

Re: Re: Sorting the values in a listbox when using an expression in the sort tab

Anonymous — Wed, 07 May 2014 11:05:11 GMT

When I unclick the expression in the sorting tab and only activate state with "ascending" and text with "a-z", I get the following:

Re: Sorting the values in a listbox when using an expression in the sort tab

Anonymous — Wed, 07 May 2014 11:18:29 GMT

I used the sorting expression whe I tried Ascending in stead of auto ascending. I have to have that expression, because the variable "aktivitetsnavn" have a filter (daily data versus yearly data). Ypu can see that I have the same expression in the general tab - because I only want to have shown a subset of the values of the variable "aktivitetsnavn".

Re: Sorting the values in a listbox when using an expression in the sort tab

Anonymous — Sun, 18 May 2014 19:17:19 GMT

I can see that you deleted the expression in the sort tab?

I have to have the expression, otherwise the associated values in the listbox "Aktivitetsnavn" doesn't appear in the top, when I choose a value in the listbox "Fakultet".

I found out that I had this problem because I had to use an expression in the general tab.

If I only had chosen a variable from my data set (instead of writing an expression), I wouldn't have any problems with the sorting in the listbox and I wouldn't have any problems with the associated values not being shown in the top of the listbox.

BUT I have to use the expression in the genereal tab, becuase otherwise I get too many values in the listbox - and in the one sheet I only need data with the daily data and in the other sheet I only need the yearly data being shown.

I discovered that because of the expression in the general tab, I had to copy the expression into the sort tab also - otherwise the associated values didn't appear in the top of the listbox. But this resulted in the values in the listbox not being shown in alphabetic order.

Re: Sorting the values in a listbox when using an expression in the sort tab

Anonymous — Tue, 20 May 2014 07:30:10 GMT

I got a tip from Stackoverflow that said:

There are multiple solutions on this, but I think the correct one, would be to create a field in your datamodel, that contains just the values that need in the listbox.

Listboxes are not very good at filtering data. So take your if statement, and put it into the source table:

if(datakilde='Aarlig', Aktivitetsnavn) as Aktivitetsnavn_2

Then you don't have to struggle with filtering data in listboxes and your sorting will be correct.

After I put the if statement in the script instead of the listbox, it worked. Now I don't need to use an expression in the general tab and because of that I don't have any problems with the associated values not being shown i the top of the listbox. And therefore I don't need the expression i the sort tab either- which now has resulted in no problems with the sorting in the listbox.