Importing XLSX

[#1]

• - How can I import the .xlsx file that has a compound row of columns?

Example:

What I’m wanting to do is basically have the Category line up with each other (03 with 03, 04 with 04, etc.).

So when I import the data it’s all in one line and that I can remove what I don’t want.

What the end result is supposed to be is that I can show the actual cost versus the forecasted cost of each category BY MONTH.

So what steps can I take to achieve this?

Thank you,

Andrew

Message was edited by: Andrew Dang

[saumyashah90]

Can you please show the output you want and also a dummy file if you can load for the same.

[#3]

I have added a dummy file that can be used.

As for the output, I'm not sure what exactly to show you.
But here is what I want to show on Qlikview. I want to be able to view this by month as I select.

I want to be able to view the costs of each category actual and the forecast.

Thanks again,

Andrew

[#4]

Dang,

Please see attached qvw. I just change the month to number. When you load from excel you can clear un-want columns and rows.

First load one tab to get the script then change loading script with variable to load two tabs.

Thanks.

[#5]

Hi dust0000‌, Thank you for your input on this question.

What you have attached isn't quite what I'm looking for, since it is not showing the actual vs forecast by each category, sorted by month. Also, I'm not trying to add any new tabs to the .xlsx file since this report is updated monthly and typically as a read-only file. 

-Andrew

[#6 · Accepted solution]

Please see attached qvw with your original data load. All the data is there and you can create chart on your needs.

Thanks.