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: 
chandu441
Creator
Creator

Getting wrong Count of Rows inserted in QVD File from Main Source Data

Hi,

I'm having 22375 Rows in the Main Data Source.

1.png

I have loaded the data in the Qlikview and tried to convert the data into QVD Format.

When after converting it into QVD Format it  is showing the data only 100000 Rows in the file.

2.png

Please let me know how can I view the full length data same as like main data source in QVD file.

For reference I've attached images of the files with red colored.

1 Solution

Accepted Solutions
Anonymous
Not applicable

Well that's why you are only seeing 100,000 rows.

To see them all with EasyQlik QViewer you will need to splash the cash and buy a licence.

View solution in original post

11 Replies
ankit777
Specialist
Specialist

Hi,

Are you making any join during reload in script?

chandu441
Creator
Creator
Author

No I m not using any Join, Concatenate functions. I've given Noconcatenate function only for making it different tables.

ankit777
Specialist
Specialist

Hi,

check the frequency of S.No field values. It should be one for all. If its more than one then data is duplicated.

If its 1 for all values, then QV is reading some garbage data from the excel.

antoniotiman
Master III
Master III

From EasyQlik.com

Disclaimer

Application is offered "as is", without warranties and liabilities. You may not resell it, disassemble or offer it under a different branding.

Free version has limit of 50'000 100'000 rows. If a QVD file has more rows then only first 100'000 will be loaded which is often enough for data profiling. To get full version purchase a license.

Regards,

Antonio

antoniotiman
Master III
Master III

Free version has limit of 50'000 100'000 rows.

jvitantonio
Luminary Alumni
Luminary Alumni

Hi, that's not a count. you are using Qlikviewer which  will show only a set of your data. If you want to properly check your count, load your data into a QVW file and check in your out put the amount of records or use a text box with expression =count([S.No])

JV

Anonymous
Not applicable

Are you using the free version of EasyQlik QViewer to count the rows ?

If so then this free version has a limit of 100,000 rows, which explains why it only shows 100,000 rows.

chandu441
Creator
Creator
Author

Dude's  One thing I didnt mention

The QlikViewer which i am using is free version

Anonymous
Not applicable

Well that's why you are only seeing 100,000 rows.

To see them all with EasyQlik QViewer you will need to splash the cash and buy a licence.