topic Consolidating excel sheets in QlikView https://community.qlik.com/t5/QlikView/Consolidating-excel-sheets/m-p/879040#M1015939 <HTML><HEAD></HEAD><BODY><P>Hello Guys,</P><P></P><P>I have an excel sheet (see attached), in 1st sheet I have a dataset with Euro, in 2nd sheet I have dataset with USD, I want to achieve the 3rd sheet using Qlikview i.e. I have to combine both data sources (usd and euro) and consolidate it in one sheet (as shown in the 3rd consolidated sheet). </P><P></P><P>The datasource has the following hierarchy/structure</P><P></P><P>without space I have company</P><P>3 spaces before I have a group</P><P>5 spaces before I have a product</P><P></P><P>company total = total of groups</P><P>group total = total of products</P><P></P><P>Number of products (under specific group) can vary in datasets.</P><P></P><P>Please guide how it can be achieved in Qlikview.</P><P></P><P>Thanks and Regards,</P><P>Muhammad Raza</P></BODY></HTML> Wed, 08 Apr 2015 20:14:58 GMT muhammadraza 2015-04-08T20:14:58Z Consolidating excel sheets https://community.qlik.com/t5/QlikView/Consolidating-excel-sheets/m-p/879040#M1015939 <HTML><HEAD></HEAD><BODY><P>Hello Guys,</P><P></P><P>I have an excel sheet (see attached), in 1st sheet I have a dataset with Euro, in 2nd sheet I have dataset with USD, I want to achieve the 3rd sheet using Qlikview i.e. I have to combine both data sources (usd and euro) and consolidate it in one sheet (as shown in the 3rd consolidated sheet). </P><P></P><P>The datasource has the following hierarchy/structure</P><P></P><P>without space I have company</P><P>3 spaces before I have a group</P><P>5 spaces before I have a product</P><P></P><P>company total = total of groups</P><P>group total = total of products</P><P></P><P>Number of products (under specific group) can vary in datasets.</P><P></P><P>Please guide how it can be achieved in Qlikview.</P><P></P><P>Thanks and Regards,</P><P>Muhammad Raza</P></BODY></HTML> Wed, 08 Apr 2015 20:14:58 GMT https://community.qlik.com/t5/QlikView/Consolidating-excel-sheets/m-p/879040#M1015939 muhammadraza 2015-04-08T20:14:58Z