Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Contributor II

Re: data in Database table but not in qlikview table

what is the error description ?

Vegar
Valued Contributor

Re: data in Database table but not in qlikview table

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?

Please ekskuse my Norglish and Swenglish typos.
Not applicable

Re: data in Database table but not in qlikview table

Thanks

Vegar
Valued Contributor

Re: data in Database table but not in qlikview table

Glad I could help

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

Please ekskuse my Norglish and Swenglish typos.
Not applicable

Re: data in Database table but not in qlikview table

No

sujeetsingh
Honored Contributor III

Re: data in Database table but not in qlikview table

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

Re: data in Database table but not in qlikview table

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
Contributor II

Re: data in Database table but not in qlikview table

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
Valued Contributor

Re: data in Database table but not in qlikview table

Could you  post the query you are trying to run?

Please ekskuse my Norglish and Swenglish typos.
Community Browser