topic Create hierarchy from 1 column in QlikView https://community.qlik.com/t5/QlikView/Create-hierarchy-from-1-column/m-p/768857#M273074 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have an excel sheet which contains two colums: ID# (ie ID1, ID2, ID3, ID4) and Workname (every ID has multiple worknames)</P><P></P><P>In another Excel I have the ID's and worknames in different columns, so every ID is a different column.</P><P></P><P>If I would load this sheet I would be able to create a group with the different columns to create a hierarchy BUT, I need to have the first excel in order to match other data. Is there a way I can create the hierarchy with the first Excel?</P><P></P><P>Regards, Paul</P></BODY></HTML> Mon, 23 Mar 2015 11:47:01 GMT pauldamen 2015-03-23T11:47:01Z Create hierarchy from 1 column https://community.qlik.com/t5/QlikView/Create-hierarchy-from-1-column/m-p/768857#M273074 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have an excel sheet which contains two colums: ID# (ie ID1, ID2, ID3, ID4) and Workname (every ID has multiple worknames)</P><P></P><P>In another Excel I have the ID's and worknames in different columns, so every ID is a different column.</P><P></P><P>If I would load this sheet I would be able to create a group with the different columns to create a hierarchy BUT, I need to have the first excel in order to match other data. Is there a way I can create the hierarchy with the first Excel?</P><P></P><P>Regards, Paul</P></BODY></HTML> Mon, 23 Mar 2015 11:47:01 GMT https://community.qlik.com/t5/QlikView/Create-hierarchy-from-1-column/m-p/768857#M273074 pauldamen 2015-03-23T11:47:01Z