Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am having a problem loading the data from my excel spreadsheet into qlikview. I have a sheet in excel that has Mon-Fri with values 1 listed for each day of the week like the following table...
Mon | Tues | Wed | Thurs | Fri |
---|---|---|---|---|
1 | 1 | 1 | 1 | 1 |
1 | 1 | 1 | 1 | 1 |
1 | 1 | 1 | 1 | 1 |
1 | 1 | 1 | 1 | 1 |
I load up the data all the data is shown the the "table file" load under the script editor and it says it "loads 5 rows" which is correct. Whenever i go to create a table box it only displays the header and the first row of data.. such as
Mon | Tues | Wed | Thurs | Fri |
---|---|---|---|---|
1 | 1 | 1 | 1 | 1 |
I have no clue why only the first row of data is being presented and not the entire 5 rows.. Does anyone have any clue why this is happening?
Hi,
Try this way and add the field RowNo() in the load script like
Load
Rowno() as Rowid,
Mon,
Tues,
Wed,
Thrus,
Fri
From Source;
Regards
Anand
Hi,
Try this way and add the field RowNo() in the load script like
Load
Rowno() as Rowid,
Mon,
Tues,
Wed,
Thrus,
Fri
From Source;
Regards
Anand
QlikView will automatically group your data by distinct values. If you simply add a Row ID (to make unique) then you should see all five rows.
Good luck
Oscar
Assume you load this table with
LOAD
RowNo() as Rid,
RecNo() as RecordNo,
Mon,Tues,Wed,Thrus,Fri;
LOAD * Inline
[
Mon,Tues,Wed,Thrus,Fri
1,1,1,1,1
1,1,1,1,1
1,1,1,1,1
1,1,1,1,1
];
Actually it loads all rows but due to same records that not visible if you press Ctrl + T and view records you can see all rows for check this add Rowno() for numbering the rows or you can count this in any text object like =Count(Mon).
Hope this helps
Regards
Anand