topic Importing XLSX in QlikView

Importing XLSX

Mon, 07 Dec 2015 16:25:54 GMT

- 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

Re: Importing XLSX

saumyashah90 — Tue, 08 Dec 2015 02:27:13 GMT

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

Re: Importing XLSX

Tue, 08 Dec 2015 17:20:40 GMT

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

Re: Importing XLSX

Tue, 08 Dec 2015 18:52:47 GMT

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.

Re: Importing XLSX

Wed, 09 Dec 2015 14:48:26 GMT

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

Re: Importing XLSX

Wed, 09 Dec 2015 19:30:47 GMT

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

Thanks.