Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
shannoypaul
Creator
Creator

Record Count Mismatch

Hi,

I am reading data from an excel file, using cross tab function. The new table now consists of 780 records.
I am making a QVD for this new table and again reading it from the QVD, now it reads only 775 records.

I thought there was some issue with my script, but I checked using a two table boxes one having the excel read contents and the other containing QVD read contents. Both of the table boxes had 775 records. Further i checked data in excel, it is completely perfect.

Then why was it showing 780 records being record, it still shows the same but no issues with the data.

Please let me know if I have missed out anything.

Thanks in advance!

1 Solution

Accepted Solutions
Not applicable

It could be an issue with the source excel file. I had the same issue recently when trying to upload the data. After trial and error I managed to tally the records between the excel file and the table.

Open your excel file, go to the last record in the sheet, select all the rows below the last record (technically all empty rows) and delete it. Re-run the script and see if the count matches.

This worked for me but honestly I am not sure why it causes such a problem in the first place.

Hope this helps.

View solution in original post

5 Replies
Not applicable

Any chance there are duplicate records in your Excel file? QlikView will only hold the unique records across all fields.

marcus_sommer

You could use rowno() or recno() to make each row definitely unique. Further you could look at the table-viewer (ctrl+t) and/or create a structure-table (right click in sheet --> new objects --> structure-table) to investigate your data-structure.

- Marcus

Not applicable

Post your script. do you write some distinct in the script?

Marco

Not applicable

It could be an issue with the source excel file. I had the same issue recently when trying to upload the data. After trial and error I managed to tally the records between the excel file and the table.

Open your excel file, go to the last record in the sheet, select all the rows below the last record (technically all empty rows) and delete it. Re-run the script and see if the count matches.

This worked for me but honestly I am not sure why it causes such a problem in the first place.

Hope this helps.

Not applicable

Below are the possible cases:

1. If you using Cross function for loading, please check is there any null values exist on the Data field values. Cross table wont load the Null values. Use Isnull condition to convert null value in the zero.

2. In Table Boxes, QLikview will show unique values only. Use Row No or Rec No function to create the unique key on the the each row.