Excel import - only 50 rows - why?

[Anonymous]

Hi,

i imported an simple excel table (see attachment) with 135 rows, but only 50 rows were imported.

I use QlikSense Desktop. Windows 8.

What´s the problem?

Best regards

Homer

[#2 · Accepted solution]

I just tested it and it doesn't seem that there's any issue with excel file. Can you try again? ...And go to "Data Model viewer" to see the number of rows imported after "Load and Finish" step.

[ogster1974]

if you look at the data in preview mode it will only display a subset of data.

Do as Paras suggests and check the number of rows in your data or you can create a simple KPI Visualisation

with =count(distinct Zahl) as your measure.

Regards

Andy

[Anonymous]

Hi,

i did it and it shows 134 rows. Thank you!

Best regards

Homer