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: 
Not applicable

data in Database table but not in qlikview table


Hi,

When I doing query in database, It is giving data. But not in qlikview.

How to check?

Thanks

Amit

12 Replies
marwen_garwachi
Creator II
Creator II

what is the error description ?

Vegar
MVP
MVP

1. Did you remember to add "SQL" in front of the SELECT statement in Qlikview?

SQL SELECT ...

2. Is your ODBC pointing to the same schema you are using when query the database outside of qlikview?

Not applicable
Author

Thanks

Vegar
MVP
MVP

Glad I could help

If my comment helped you then please mark this question as answered.

Not applicable
Author

No

sujeetsingh
Master III
Master III

Amit,

First check the connection.

Are you following the right way to connect the data base

Edit script and then debug

Check that the data base connection is done

Then see the outcome rows of query

ashfaq_haseeb
Champion III
Champion III

Hi,

You need to look at rowno() and recno()

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

Regards

ASHFAQ

vinay_hg
Creator III
Creator III

1. check wheather data is reloaded properly or not in your raw load. i mean intiall load of qvd.

if yes.. then there must be a problem in the logic applied in the middle.

if no... data is not reloading properly. check your connection string. delete and add it again and reload.

and also check from when the data is not loaded i mean if there is a date field check from which row data is not loaded in ur qvd.. is it random data missed or complete set of data missed.

and mainy check if there is any where condition in ur load which is causing the data not loading in ur qvd or qvw file

Vegar
MVP
MVP

Could you  post the query you are trying to run?