Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Loading Hierarchical Excel Sheet

Hi,

I'm having trouble loading the attached spreadsheet into Qlikview.  It comes in a heirarchical format where the first row is region name, second row is state name, third row is type of unit and the fourth row has both the date header and names of the units, then the rest of the rows contain the data .  If it is possible I would like to have it in the following format in Qlikview:

DateRegionStateUnit Type
Unit NameMW
1/1/2008Pacific NorthwestIDPeakingEvander0
......WANon-PeakingChehalis0
......ORPeakingBeaver72991

Also it would be ideal for me to not have to tweak the spreadsheet at all, if possible.

Any suggestions would be highly appreciated.

Tags (2)
1 Solution

Accepted Solutions

Re: Loading Hierarchical Excel Sheet

See here for a solution.


talk is cheap, supply exceeds demand
3 Replies
Not applicable

Re: Loading Hierarchical Excel Sheet

I don't see how there would be a work around in this format. Typically Hierarchies are done with a delimiter and in a simpler format for QV to pull in. Merged cells like this horizontal layout wont be easy. The way it would do it is like this;

Pacific Northwest>ID>Peaking>Evander>0

Repeat same on next row.

Then in your list use the > or any symbol you want.  It loads very nice and it easy to use by end users.

Re: Loading Hierarchical Excel Sheet

See here for a solution.


talk is cheap, supply exceeds demand
Not applicable

Re: Loading Hierarchical Excel Sheet

Gysbert - The info in that thread seems to be exactly what I was looking for, thanks!

Community Browser