topic Sorting List Box when "Show as TreeView" is flaged in QlikView

Sorting List Box when "Show as TreeView" is flaged

Mon, 21 Mar 2011 00:56:35 GMT

Hi there,

I have a listbox with "Show as TreeView". When I select a node, there is no sorting. If I unflag the treeview, i.e. a normal listbox, the sorting works Ok.

Has someone faced this problem? Any suggestions?

Thanks in advance.

Sorting List Box when "Show as TreeView" is flaged

Miguel_Angel_Baeyens — Mon, 21 Mar 2011 07:23:48 GMT

Hello,

I'm using a very simple example of treeview, sorted as it comes by default Text (A-Z) and it's working fine. I've changed the sort option to descending and keeps sorting fine. Are you using numerical sort? Try with the text sort. Can you post a sample of your data?

Hope that helps.

Sorting List Box when "Show as TreeView" is flaged

Mon, 21 Mar 2011 11:35:53 GMT

I'm sorry: the problem occurs in "Sort by State - Auto Ascending".

See the attached file.

Thanks.

Sorting List Box when "Show as TreeView" is flaged

Mon, 21 Mar 2011 11:57:25 GMT

Hi, I am able to sort with alphabet in the provided application.Can you please detail your query.?

Sorting List Box when "Show as TreeView" is flaged

Miguel_Angel_Baeyens — Mon, 21 Mar 2011 12:20:11 GMT

Hi,

The State order is based on selections, so yes, it may "unsort" your list because some of their elements are selected. This is useful since it shows first the selections done. But in your case, where the hierarchy is important, I wouldn't use the State sort.

Anyway, I see your list sorted alphabetically, when I open "Qualidade" I see the child values sorted.

What is your expected result?

Sorting List Box when "Show as TreeView" is flaged

Mon, 21 Mar 2011 12:30:27 GMT

Hi, Miguel.

In this particular case, I expected that "Qualidade" was on top, once is selected. The worst behaviour is when you hide the excluded items. Try to do this and you'll see "black holes" on the listbox.

Thanks again.

Sorting List Box when "Show as TreeView" is flaged

Miguel_Angel_Baeyens — Mon, 21 Mar 2011 12:45:33 GMT

Hello,

It behaves as I'd expect, since its only ONE value in one field, although formatted to be shown in one or another way. So yes, if you select "Hide Excluded", and since there is no possible value at top level (you cannot select parents, but only the lowest level of the treeview), all but Produçao, that is the only possible value selectable, is hidden.

I mean, when you clear all fields, all parent values appear greyed (not possible, excluded). You may need to create an actual hierarchy load, so all values are selectable, so possible, and thus the listbox will appear white always.

Hope that helps.

Sorting List Box when "Show as TreeView" is flaged

Mon, 21 Mar 2011 12:59:48 GMT

Thank you, Miguel.

I'll try to improve the quality of my data, but realize that even Produção doesn't stay on top if is selected.

Anyway, with better data I reply again.

Regards

Sorting List Box when "Show as TreeView" is flaged

Mon, 21 Mar 2011 13:37:01 GMT

Miguel,

Follows a new example file. Realize that all parents exists.

I've set the "Hide Excluded" on both list boxs and selected the Qualidade/Concentracao I

So, don't you think that both lists should be sorted (by state)?

And, why the parent was hidden, once we are talking about hierarchical data?

If this is the expected behaviour, do you have some suggestions to address my requisite? I mean: I need to show only the possible values (included parents) wihout blanks on listbox.

Thank you.

Sorting List Box when "Show as TreeView" is flaged

Miguel_Angel_Baeyens — Mon, 21 Mar 2011 16:33:18 GMT

Hi,

It's not hierarchical data, it's just one value of one field (the same value) but displayed using a separator. I meant a HIERARCHY LOAD in the script, so for each value in the lowest level there are some corresponding values in higher levels, so there are at least as many fields as levels.

Something like this example.

Hope that helps.

Sorting List Box when "Show as TreeView" is flaged

Mon, 21 Mar 2011 19:46:02 GMT

I understood the explanation.

Unfortunately, the treeview behaviour (even in the example you send) doesn't work as I expected. There is no sorting and, if you flag the Hide Excluded, parents are hidden.

Thanks.