Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jerry_ile
Contributor III
Contributor III

QlikSense not showing all excel rows

Hi,

Using Qlik sense I have a connection to a excel sheet on our network that  I am performing a cross tab on.

However the connection is not showing all of the data, I have 105 rows in the excel sheet which is based on a power query (may make a difference ...not sure )

Problem is Qlik is only showing and importing the 1st 9 rows

Excel sheet

tempsnip.png

This is the Qlik import

tempsnip2.png

 

Any ideas on why it's not importing the entire sheet and how to resolve 

 

Kind regards

Jerry

Labels (3)
2 Replies
emrekaya
Contributor III
Contributor III

Did you try after you imported the page into qliksense? You can create a table and check whether it has all the rows or not.
jerry_ile
Contributor III
Contributor III
Author

Yes there is data there not all, but more then shows in the connection so must be something to do with my associations or load script.

 

Thanks I will look again