Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview not loading entire data

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...

MonTuesWedThursFri
11111
11111
11111
11111

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

MonTuesWedThursFri
11111

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?

1 Solution

Accepted Solutions
its_anandrjs

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

View solution in original post

3 Replies
its_anandrjs

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
Partner - Specialist
Partner - Specialist

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

];

freq.png

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