Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.


Consolidating excel sheets

Hello Guys,

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).

The datasource has the following hierarchy/structure

without space I have company

3 spaces before I have a group

5 spaces before I have a product

company total = total of groups

group total = total of products

Number of products (under specific group) can vary in datasets.

Please guide how it can be achieved in Qlikview.

Thanks and Regards,

Muhammad Raza

Tags (1)