topic Re: Getting wrong Count of Rows inserted in QVD File from Main Source Data in QlikView

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

chandu441 — Mon, 29 Jun 2015 12:17:25 GMT

Hi,

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

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.

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.

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

ankit777 — Mon, 29 Jun 2015 12:19:16 GMT

Hi,

Are you making any join during reload in script?

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

chandu441 — Mon, 29 Jun 2015 12:24:15 GMT

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

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

ankit777 — Mon, 29 Jun 2015 12:27:29 GMT

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.

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

antoniotiman — Mon, 29 Jun 2015 12:28:12 GMT

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

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

antoniotiman — Mon, 29 Jun 2015 12:29:49 GMT

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

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

jvitantonio — Mon, 29 Jun 2015 12:30:46 GMT

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])

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

Anonymous — Mon, 29 Jun 2015 12:31:37 GMT

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.

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

chandu441 — Mon, 29 Jun 2015 12:34:31 GMT

Dude's One thing I didnt mention

The QlikViewer which i am using is free version

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

Anonymous — Mon, 29 Jun 2015 12:38:19 GMT

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.

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

jvitantonio — Mon, 29 Jun 2015 12:46:05 GMT

The records are there, you just can't see them in EasyQlik QViewer. Load the QVD in a QVW file and you'll be able to see all the data.

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

chandu441 — Mon, 29 Jun 2015 16:30:30 GMT

Ya juan vitantonio I did the solution which you suggested for me. I got it bro.

Thank you soo much