topic Qlikview not loading entire data in QlikView

Qlikview not loading entire data

Wed, 17 Dec 2014 20:45:59 GMT

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?

Re: Qlikview not loading entire data

its_anandrjs — Wed, 17 Dec 2014 20:52:16 GMT

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

Re: Qlikview not loading entire data

oscar_ortiz — Wed, 17 Dec 2014 20:53:28 GMT

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

Re: Qlikview not loading entire data

its_anandrjs — Wed, 17 Dec 2014 21:00:53 GMT

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

];

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