topic Re: Inputting an excel table with multiple headers in QlikView

Inputting an excel table with multiple headers

josielaidlaw — Sat, 16 Nov 2024 04:35:51 GMT

Hi QC!

I am fairly new to Qlikview, and thought I knew what I was doing until I tried to input a table from Excel today. I have a complex excel table, with multiple levels of column headers (ie fiscal year, and then months) as well as the left column being all row headers. I cannot figure out how to import this into Qlikview without messing up the data structure. Ideally, all I want to do is create a line graph where I can show the various row headers and their values over the fiscal year (each having values for each month).

Any suggestions? Or is this not possible?

Thanks!

Re: Inputting an excel table with multiple headers

MindaugasBacius — Thu, 31 Jan 2019 14:17:23 GMT

First suggestion read about Crosstable https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083.
Secondly I strongly suggest studing Transforming table with default Wizard.

In case you would like us to help and get you the results you wish please upload the excel spreadsheet. Besides that result do you expect?

Thank you

Re: Inputting an excel table with multiple headers

mrybalko — Thu, 31 Jan 2019 15:16:13 GMT

Hello. The load is possible. It is better to attach sample data.

The main point is table transposing and using crosstable function. I will explain step by step:

Step 1. Start with load file wizard

Step 2. Enable transformation step. Transpose tableStep 3. Fill empty cells with above values in columns 1-4Step 4. Table view after fillingStep 5. Add labels and use crosstableStep 6. Set crosstble params

Re: Inputting an excel table with multiple headers

Haarika — Mon, 27 May 2019 19:48:51 GMT

Hey, I exactly have the same requirement in qliksense. unfortunately I dont have QV installed on my machine to view the script you attached in this blog. Could you please paste the script here so that I can view it. Many Thanks

Re: Inputting an excel table with multiple headers

Haarika — Mon, 27 May 2019 20:49:13 GMT

I have just read that, Transpose function is not recommended to be used in QS. Hence, could you please advise on how we achieve in transforming exactly the same excel data format in qliksense.