topic Hierarchy with left keep in QlikView https://community.qlik.com/t5/QlikView/Hierarchy-with-left-keep/m-p/150863#M28817 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>I'm using hierarchy function to group accounts and link them to transactions table. Unfortunately, "left keep" function that links accounts table with transactions (Account_ID is the key) intereferes hierarchy - only one group is built instead of four. Please see the code and help:</P><P></P><P>AccountsTable:</P><P><STRONG>LEFT KEEP</STRONG> (TransactionsTable)</P><P><STRONG>LOAD</STRONG> Account_ID, Parent_ID, Account_Name;</P><P><STRONG>HIERARCHY</STRONG> (Account_ID, Parent_ID, Account_Name)</P><P><STRONG>SQL SELEC</STRONG><STRONG>T</STRONG> "Acc_AccId" AS Account_ID,</P><P>"Acc_Nazwa" AS Account_Name,</P><P>"Acc_ParId" AS Parent_ID</P><P><STRONG>FROM</STRONG> "CDN".CDN.Accounts;</P><P></P><P>AccountsTable:</P><P><STRONG></STRONG></P><P><STRONG></STRONG></P><P><STRONG></STRONG></P><P><STRONG></STRONG></P><P><STRONG></STRONG></P><P><STRONG><STRONG>LOAD</STRONG> Account_ID, Parent_ID, Account_Name;</STRONG></P><P><STRONG>HIERARCHY</STRONG> (Account_ID, Parent_ID, Account_Name)</P><P><STRONG>RESIDENT</STRONG> AccountsTable;</P><BR /><BR /> <P></P><P>Thank you,</P><P>Przemek</P><P></P></BODY></HTML> Sat, 01 Aug 2009 18:48:49 GMT 2009-08-01T18:48:49Z Hierarchy with left keep https://community.qlik.com/t5/QlikView/Hierarchy-with-left-keep/m-p/150863#M28817 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>I'm using hierarchy function to group accounts and link them to transactions table. Unfortunately, "left keep" function that links accounts table with transactions (Account_ID is the key) intereferes hierarchy - only one group is built instead of four. Please see the code and help:</P><P></P><P>AccountsTable:</P><P><STRONG>LEFT KEEP</STRONG> (TransactionsTable)</P><P><STRONG>LOAD</STRONG> Account_ID, Parent_ID, Account_Name;</P><P><STRONG>HIERARCHY</STRONG> (Account_ID, Parent_ID, Account_Name)</P><P><STRONG>SQL SELEC</STRONG><STRONG>T</STRONG> "Acc_AccId" AS Account_ID,</P><P>"Acc_Nazwa" AS Account_Name,</P><P>"Acc_ParId" AS Parent_ID</P><P><STRONG>FROM</STRONG> "CDN".CDN.Accounts;</P><P></P><P>AccountsTable:</P><P><STRONG></STRONG></P><P><STRONG></STRONG></P><P><STRONG></STRONG></P><P><STRONG></STRONG></P><P><STRONG></STRONG></P><P><STRONG><STRONG>LOAD</STRONG> Account_ID, Parent_ID, Account_Name;</STRONG></P><P><STRONG>HIERARCHY</STRONG> (Account_ID, Parent_ID, Account_Name)</P><P><STRONG>RESIDENT</STRONG> AccountsTable;</P><BR /><BR /> <P></P><P>Thank you,</P><P>Przemek</P><P></P></BODY></HTML> Sat, 01 Aug 2009 18:48:49 GMT https://community.qlik.com/t5/QlikView/Hierarchy-with-left-keep/m-p/150863#M28817 2009-08-01T18:48:49Z