topic Re: Performance Tree View Listbox in QlikView https://community.qlik.com/t5/QlikView/Performance-Tree-View-Listbox/m-p/951490#M327232 <HTML><HEAD></HEAD><BODY><P>I used this:</P><P></P><P></P><P class="p1"><SPAN class="s1">Hierarchy</SPAN><SPAN class="s2">(</SPAN>NodeID<SPAN class="s2">, </SPAN>ParentID<SPAN class="s2">, </SPAN>NodeName<SPAN class="s2">,,</SPAN>NodeName<SPAN class="s2">, </SPAN>HierarchyPath<SPAN class="s2">, '|', </SPAN>[Depth]<SPAN class="s2">) </SPAN></P><P class="p1"></P><P class="p1">And then a listbox with treeview enabled with HierarchyPath as dimension and no expression.</P></BODY></HTML> Sun, 11 Oct 2015 11:18:41 GMT amien 2015-10-11T11:18:41Z Performance Tree View Listbox https://community.qlik.com/t5/QlikView/Performance-Tree-View-Listbox/m-p/951488#M327230 <HTML><HEAD></HEAD><BODY><P>!I created a hierarchy load which results in about 600.000 records and 4 node levels.</P><P>when i create the listbox with treeview it takes about 30 seconds to create it. When its rendered the performance itself is very good.</P><P>Also when the enduser switches to another sheet, rendering the treeview also takes very long (not workable).</P><P></P><P>Anyone also had performance issues with the treeview? What can i do to optimize? (sorry can't share the qvw)</P></BODY></HTML> Sun, 11 Oct 2015 10:59:22 GMT https://community.qlik.com/t5/QlikView/Performance-Tree-View-Listbox/m-p/951488#M327230 amien 2015-10-11T10:59:22Z Re: Performance Tree View Listbox https://community.qlik.com/t5/QlikView/Performance-Tree-View-Listbox/m-p/951489#M327231 <HTML><HEAD></HEAD><BODY><P>Did you use a path field or create the path in a list box expression?</P><P></P><P>Regards</P><P></P><P>Marco</P></BODY></HTML> Sun, 11 Oct 2015 11:16:22 GMT https://community.qlik.com/t5/QlikView/Performance-Tree-View-Listbox/m-p/951489#M327231 MarcoWedel 2015-10-11T11:16:22Z Re: Performance Tree View Listbox https://community.qlik.com/t5/QlikView/Performance-Tree-View-Listbox/m-p/951490#M327232 <HTML><HEAD></HEAD><BODY><P>I used this:</P><P></P><P></P><P class="p1"><SPAN class="s1">Hierarchy</SPAN><SPAN class="s2">(</SPAN>NodeID<SPAN class="s2">, </SPAN>ParentID<SPAN class="s2">, </SPAN>NodeName<SPAN class="s2">,,</SPAN>NodeName<SPAN class="s2">, </SPAN>HierarchyPath<SPAN class="s2">, '|', </SPAN>[Depth]<SPAN class="s2">) </SPAN></P><P class="p1"></P><P class="p1">And then a listbox with treeview enabled with HierarchyPath as dimension and no expression.</P></BODY></HTML> Sun, 11 Oct 2015 11:18:41 GMT https://community.qlik.com/t5/QlikView/Performance-Tree-View-Listbox/m-p/951490#M327232 amien 2015-10-11T11:18:41Z Re: Performance Tree View Listbox https://community.qlik.com/t5/QlikView/Performance-Tree-View-Listbox/m-p/951491#M327233 <HTML><HEAD></HEAD><BODY><P>I added an example in the first post (Thanks Sander)</P></BODY></HTML> Mon, 12 Oct 2015 21:36:23 GMT https://community.qlik.com/t5/QlikView/Performance-Tree-View-Listbox/m-p/951491#M327233 amien 2015-10-12T21:36:23Z