Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Importing XLSX

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

Example:

qlik.JPG

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

1 Solution

Accepted Solutions
Not applicable
Author

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

Thanks.

View solution in original post

5 Replies
saumyashah90
Specialist
Specialist

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

Not applicable
Author

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.
Act vs Fore.JPG

Thanks again,

Andrew

Not applicable
Author

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.

Not applicable
Author

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

Not applicable
Author

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

Thanks.