topic Re: Import data in QlikView

Import data

Tue, 12 Mar 2013 16:13:08 GMT

1. I'm new to QlikView and for what I can see there's no way to input data directly using the Graphical Interface.

I see that I can only import data from Excel sheets or SQL Databases.

2. So I'm trying to import the data from my first excel sheet and I'm having trouble because each 2 lines in the sheet represent 1 line of data (you can see the example attached).

3. Another thing is that I have some comments at the beginning of the sheet and I have to remove them to be able to import the sheet.

Thanks,

Miguel

Re: Import data

Tue, 12 Mar 2013 16:56:15 GMT

At least if some expert could respond to just one of my questions I would be happy.

Thanks

Re: Import data

Tue, 12 Mar 2013 17:02:47 GMT

Hi You can use Inline table to copy the excel data. That is fastest way to copy the excel data into Qlikview if your excel data is not properly organised.

Go to Ctrl + E (Script Editor) --> Insert -->Load Statement --> Load Inline