topic How to force a sort on a listbox in QlikView

How to force a sort on a listbox

Tue, 21 Apr 2015 06:34:45 GMT

I have a table that contains 2 columns,

Producat_Cat_Name and Cross_Flag. From this table I need to create a listbox that looks as follows:

Category1

Category2

Cross_Flag >>this one contains all the products that did not fit into the first 2 categories.

The listbox also needs to be sorted in the above way.

To do this I have created another table that has a sort order column, but its not working.

I have attached the App, please take a look at the properties of the Listbox.

My main problem is that once I add an expression to the sort then the fileds start to change position, looks like they are getting sorted by State, even thought I have that option disabled.

Let me know I need to provide more details.

Re: How to force a sort on a listbox

raghvendrasingh — Tue, 21 Apr 2015 06:40:47 GMT

Hi Leo,

Please attach desired solution in excel.I am not much clear about this post.

Thanks & Regards,

Raghvendra Singh

Re: How to force a sort on a listbox

Tue, 21 Apr 2015 06:50:56 GMT

I have attached an excel spreadsheet.

I just want the list box to contain values Category1, Category2, Cross_Flag

and I need them to be Sorted in that way.

Re: How to force a sort on a listbox

danieloberbilli — Tue, 21 Apr 2015 06:51:40 GMT

I would suggest to create a new dimension in the script instead of having an expression in the listbox...sorting is so much less a pain in creating a temp table with the desired sorting order and drop it at the end of the script. Then you can use the 'Load order' as sorting.

Please find attached

Re: How to force a sort on a listbox

Tue, 21 Apr 2015 06:57:23 GMT

would it still work if Im doing a binary load for my data?

Re: How to force a sort on a listbox

danieloberbilli — Tue, 21 Apr 2015 07:01:02 GMT

I think not, as the binary load must come first.

Maybe the easiest would be to have a consecutive letter or number in front and use text order like

A) Cat 1

B) Cat 2

...

Z) Cross_Flag

Re: How to force a sort on a listbox

Peter_Cammaert — Tue, 21 Apr 2015 07:52:07 GMT

You can use the dual() function in an initial/successive (after BINARY) load. This has a couple of advantages:

No weird listbox behaviour
No complex listbox expressions
Calculations are relegated to the script. If you can do it in your script, that's where you should do it.
Sort order is forced, whatever you do with it later on in the UI.

See if the attachment suits your needs.

Best,

Peter

Re: How to force a sort on a listbox

Wed, 22 Apr 2015 00:02:22 GMT

It almost worked,

But is there a bug in the software where the moment you enter any kind of expression in the Sort tab is automatically changes the sort by the state?

In other words, when I enter any expressions it begins to change the sorting after every click.