Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

quser_learn
New Contributor III

Load data from Excel

I'd like to load excel with multiple header rows in Qlikview and do charts and tables to show the data. 

Product1 Product 2
Sub-Cat1 Sub-Cat1 Oppurtunity 1 Oppurtunity 1
LocationTotal SalesSalesMkt shareSalesMkt shareProductMkt OppurtunityProductMkt Oppurtunity
A100505%202%Product 3100Product 480
B100505%202%Product 9100Product 1080

Can we load the data to qlikview as is and be able to do charts to show Oppurtunity by location & Product,  Show sales By Category and Products.  Or is it good idea to pre-process the data in to two or more tables and then load it to qlikview?

Thanks !

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Load data from Excel

It's possible to load multi row header layouts. I've created a qvw document that does this. See attached qvw. That said, you seem to have two kinds of data in your example. So it might be easier to split that into two tables in excel first.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Load data from Excel

It's possible to load multi row header layouts. I've created a qvw document that does this. See attached qvw. That said, you seem to have two kinds of data in your example. So it might be easier to split that into two tables in excel first.


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
quser_learn
New Contributor III

Re: Load data from Excel

This is amazing ... thank you very much !