Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All,
I am loading a table from excel into QLikView using
my .xls document is a table with monthly sales: rows are companies, columns are months in 2012 Jan to Dec. Into QlikView, import gives me 13 tables: one with the companies names, and 12 with sales for each months.
thanks
my script looks like this
LOAD [Corporate Account],
Jan,
Feb,
Mar,
Apr,
May
FROM
(ooxml, embedded labels, table is Sheet1);
and it brings one QlikView table per month plus one for accounts name.
can you please load your sample data file?
I enclose source xls file and obtained .qwv
use this
is it possible to open it in personal edition, as not created by me ? it seems that it is not
would you like to share how you built it, or share your script when based on a script ?
Write below script in your script editor
TableName:
CrossTable(Month, Data)
LOAD [Corporate Account],
Jan,
Feb,
Mar,
Apr,
May
FROM
Book1.xlsx
(ooxml, embedded labels, table is Sheet1);
Make sure the location of the file should be according to your file placed in your drive
thks a lot
using your script, i am getting the enclosed file. I now have three tables: Corporate accounts, Months and Data. Data is a one column table, so that it is not possible to read all the data as entered in .xls file.
Further help would be much appreciated : )
Right Click
new sheet object
Table BOx
add all
OK