Discussion Board for collaboration on QlikView Scripting.
When I doing query in database, It is giving data. But not in qlikview.
How to check?
what is the error description ?
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?
Glad I could help
If my comment helped you then please mark this question as answered.
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
You need to look at rowno() and recno()
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
Could you post the query you are trying to run?