topic Re: Need Help?? in QlikView

Need Help??

paulwalker — Sat, 18 Oct 2014 12:57:34 GMT

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 — Sat, 18 Oct 2014 13:13:21 GMT

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

paulwalker — Sat, 18 Oct 2014 16:13:46 GMT

Hi Manish,

Present i don't have data.

Any idea of this type of issue's

markodonovan — Sat, 18 Oct 2014 16:33:32 GMT

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

Sat, 18 Oct 2014 16:35:46 GMT

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 — Sun, 19 Oct 2014 13:33:29 GMT

Hi,

Go through this blog-post.

Regards

ASHFAQ

Mon, 20 Oct 2014 07:13:47 GMT

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