topic Re: Tree View list box in QlikView

Tree View list box

kmswetha — Wed, 04 Feb 2015 14:42:47 GMT

Hi,

Am using tree view by using hierarchy function.Everything is coming up well.

But when I want to put it in list box everything turns out to be gray.Is there any specific reason for this?

Re: Tree View list box

avinashelite — Wed, 04 Feb 2015 14:56:26 GMT

I think you have made some selection in the dashboard for which the tree view does not have any associated data for it hence its showing it as grey.

Re: Tree View list box

kmswetha — Wed, 04 Feb 2015 15:04:06 GMT

Hi Abinash,

I too thought the same but this is same even after clearing all the selections.

If we expand all, only the last level which as data turns to be white but not the associate higher level.

Re: Tree View list box

Wed, 04 Feb 2015 15:27:16 GMT

Can you post up an example application of what you are seeing. Sounds like you might just have the bottom level row of data only and not any of the cascades you need to make the other levels selectable.

Little example is attached, see how you need the extra rows.

hope that helps

Joe

Re: Tree View list box

MarcoWedel — Wed, 04 Feb 2015 16:37:02 GMT

Hi,

to add all nodes as separate values to a field and thus make all levels selectable in a treeview listbox, you could do like:

create a list box as TreeView having only complete dinamic path of a document

Hi,

to be able to select nodes by their parents, those have to have rows of their own in the hierarchy field.

So one solution could be:

TTREE: 
LOAD * INLINE 
[DOC,PATH,DESCRIPTION 
doc1, B/B0/B00/B00001,DESC 1 
doc2, B/B0/B00/B00002,DESC 2 
doc3, B/B0/B00/B00003,DESC 3 
doc4, B/B0/B01/B01001,DESC 4 
doc5, B/B0/B01/B01001/B010001,DESC 5 
doc6, A/A0/A00/A00001,DESC 6 
doc7, A/A0/A00/A00002,DESC 7 
doc8, A/A0/A00/A00002,DESC 8 
]; 

LOAD PATH, 
    Left(PATH,Index(PATH&'/','/',IterNo())-1) as PATH_SELECT 
Resident TTREE 
While IterNo()<=SubStringCount(PATH,'/')+1;

hope this helps

regards

Marco

Re: Tree View list box

kmswetha — Wed, 04 Feb 2015 17:17:52 GMT

Hi Joe,

My fact has data only at last level and it eventually groups based on the hierarchy.

If I don't select anything entire list box would be white, the moment I select date it turns out to be gray and only the last level in hierarchy turns white where ever data resides.

but Ideally if lower node has data and which in white, higher node should also be white rather than turning out to be gray?

Any suggestions would be appreciated?

Re: Tree View list box

Wed, 04 Feb 2015 17:33:15 GMT

Post up an example, it would be easier to help then

Re: Tree View list box

avinashelite — Thu, 05 Feb 2015 04:21:07 GMT

can you please post the app.

Re: Tree View list box

kmswetha — Thu, 05 Feb 2015 16:07:41 GMT

Hi Avinash/Joe,

Attached example has multi dimensions, when region is selected only the last level turns to be in white because of the association but not the related higher level.

Re: Tree View list box

kmswetha — Thu, 05 Feb 2015 16:50:07 GMT

Hi Macro,

This is correct, but can you take some time out and explain the logic behind this.

Regards,

Swetha

Re: Tree View list box

MarcoWedel — Thu, 05 Feb 2015 17:04:01 GMT

Hi,

this script generates a list of all parent nodes paths:

i.e. each subpath of path 'A/A0/A00/A00001' is calculated and stored in a new field 'Path_Select' associated to the given field 'Path'.

Left(PATH,Index(PATH&'/','/',IterNo())-1)

extracts those subpaths beginning from the first character to the IterNo-th occurence of the delimiter '/'.

While IterNo()<=SubStringCount(PATH,'/')+1

iterates over each input row as often as the delimiter '/' is included in the path (+1).

hope this helps

regards

Marco