topic Tree View - Bubble chart help in QlikView https://community.qlik.com/t5/QlikView/Tree-View-Bubble-chart-help/m-p/355423#M575651 <HTML><HEAD></HEAD><BODY><P>I have the attached a qvw and excel sheet for my problem. I got this example from the forum and trying to modify it to fit my needs.</P><P>1. In the excel sheet just remove the last three rows and execute the script, you will see the entire tree.</P><P></P><P>Notice the App1<SPAN style="font-family: Wingdings;">à</SPAN>App1\Default&nbsp; branch appearing.</P><P></P><P>2. Go back to the excel and undo the changes with the last three rows and check what the rows are for (just the date is different but other fields are same as the top 3).</P><P>3. Save excel sheet and Come back to Qlikview to reexecute the script.</P><P></P><P>Notice the App1<SPAN style="font-family: Wingdings;">à</SPAN>App1\Default&nbsp; branch disappeared.</P><P></P><P>Bottomline I will have these nodes repeated for every day. The tree is drawn well if we have single set of values. If the same set is repeated for the next day the tree ignores it. How can I aggregate or consolidate these rows to draw the entire tree. </P></BODY></HTML> Wed, 16 May 2012 18:52:36 GMT 2012-05-16T18:52:36Z Tree View - Bubble chart help https://community.qlik.com/t5/QlikView/Tree-View-Bubble-chart-help/m-p/355423#M575651 <HTML><HEAD></HEAD><BODY><P>I have the attached a qvw and excel sheet for my problem. I got this example from the forum and trying to modify it to fit my needs.</P><P>1. In the excel sheet just remove the last three rows and execute the script, you will see the entire tree.</P><P></P><P>Notice the App1<SPAN style="font-family: Wingdings;">à</SPAN>App1\Default&nbsp; branch appearing.</P><P></P><P>2. Go back to the excel and undo the changes with the last three rows and check what the rows are for (just the date is different but other fields are same as the top 3).</P><P>3. Save excel sheet and Come back to Qlikview to reexecute the script.</P><P></P><P>Notice the App1<SPAN style="font-family: Wingdings;">à</SPAN>App1\Default&nbsp; branch disappeared.</P><P></P><P>Bottomline I will have these nodes repeated for every day. The tree is drawn well if we have single set of values. If the same set is repeated for the next day the tree ignores it. How can I aggregate or consolidate these rows to draw the entire tree. </P></BODY></HTML> Wed, 16 May 2012 18:52:36 GMT https://community.qlik.com/t5/QlikView/Tree-View-Bubble-chart-help/m-p/355423#M575651 2012-05-16T18:52:36Z