Import data

[#1]

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

[#2]

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

Thanks

[#3]

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