Need Help??

[paulwalker]

Hi Community,

I faced one Issue.

I am extracting one table from SQL Server Database. I have created QVD.

Actually in my SQL table having 1000 records, but when i am extracting QVD it showing 900 records only.

What was the problem?? 

Thanks in Advance.......

[MK_QSL]

Without looking your database or your sql query, difficult to answer... it would be helpful if you can share something more ...

[paulwalker]

Hi Manish,

Present i don't have data.

Any idea of this type of issue's

[markodonovan]

Hi Paul,

Is it possible that there are duplicate rows ?

You could create your own unique key using rowno(), for example:

rowno() as row_id

Thanks

Mark

http://www.techstuffy.com

[#5]

Hi Paul,

please reload ur qvd once and check again because in databases date ll add in time bases ... please check it this might be one of the reason

or else u have check from witch record it is not showing the date .... in qvd that u have to compare in the database

[ashfaq_haseeb]

Hi,

Go through this blog-post.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/08/29/recno-or-rowno

Regards

ASHFAQ

[#7]

How are you checking that your qvd is having 900 records? Using Count() function or something else.

If the database is a hot replica, check if your qvd is updated with latest data or not.

Check the Script Execution Trace when you reload the application and see how many rows are pulled from qvd.

Thanks,

Singh