Qlikview not loading entire data

[#1]

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?

[its_anandrjs · Accepted solution]

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

[oscar_ortiz]

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

[its_anandrjs]

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