https://community.qlik.com/t5/QlikView/Pivot-table-Hierarchy-question/m-p/1535104#M439091 That's what I thought but wanted to ask experts before I conclude. Fri, 25 Jan 2019 12:43:07 GMT jduluc12 2019-01-25T12:43:07Z https://community.qlik.com/t5/QlikView/Pivot-table-Hierarchy-question/m-p/1535080#M439086 <P>Hi,</P><P>My data set looks like this.</P><P><U><STRONG>Parent&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Child&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Price</STRONG></U></P><P>&nbsp;Cust1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Job1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10</P><P>&nbsp;Job1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Job2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20</P><P>Job2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Job3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30</P><P>&nbsp;</P><P>Now the report that I want is</P><P>&nbsp;</P><P><U><STRONG>Parent-Level-1&nbsp; &nbsp; &nbsp; Parent-Level-2&nbsp; &nbsp; &nbsp; &nbsp; Parent-Level-3&nbsp; &nbsp; &nbsp; &nbsp; Parent-Level-4&nbsp; &nbsp; &nbsp; Price</STRONG></U></P><P>Cust1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Job1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10</P><P>Cust1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Job1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Job2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20</P><P>Cust1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Job1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Job2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Job3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30</P><P>&nbsp;</P><P>Is it possible to do it without any change in the load script?</P><P>Thanks,</P><P>Jean&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 04:39:46 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Hierarchy-question/m-p/1535080#M439086 jduluc12 2024-11-16T04:39:46Z https://community.qlik.com/t5/QlikView/Pivot-table-Hierarchy-question/m-p/1535099#M439089 I believe no. Fri, 25 Jan 2019 12:40:12 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Hierarchy-question/m-p/1535099#M439089 agni_gold 2019-01-25T12:40:12Z https://community.qlik.com/t5/QlikView/Pivot-table-Hierarchy-question/m-p/1535104#M439091 That's what I thought but wanted to ask experts before I conclude. Fri, 25 Jan 2019 12:43:07 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Hierarchy-question/m-p/1535104#M439091 jduluc12 2019-01-25T12:43:07Z