topic Re: data in Database table but not in qlikview table in QlikView

data in Database table but not in qlikview table

Tue, 25 Nov 2014 13:37:41 GMT

Hi,

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

How to check?

Thanks

Amit

Re: data in Database table but not in qlikview table

marwen_garwachi — Tue, 25 Nov 2014 13:44:31 GMT

what is the error description ?

Re: data in Database table but not in qlikview table

Vegar — Tue, 25 Nov 2014 14:27:02 GMT

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?

Re: data in Database table but not in qlikview table

Tue, 25 Nov 2014 14:27:51 GMT

Thanks

Re: data in Database table but not in qlikview table

Vegar — Tue, 25 Nov 2014 17:20:46 GMT

Glad I could help

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

Re: data in Database table but not in qlikview table

Wed, 26 Nov 2014 06:45:26 GMT

Re: data in Database table but not in qlikview table

sujeetsingh — Wed, 26 Nov 2014 06:49:51 GMT

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

ashfaq_haseeb — Wed, 26 Nov 2014 07:05:22 GMT

Hi,

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

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

Regards

ASHFAQ

Re: data in Database table but not in qlikview table

vinay_hg — Wed, 26 Nov 2014 07:07:13 GMT

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

Re: data in Database table but not in qlikview table

Vegar — Wed, 26 Nov 2014 07:08:40 GMT

Could you post the query you are trying to run?

Re: data in Database table but not in qlikview table

Anonymous — Wed, 26 Nov 2014 07:24:48 GMT

Hi Amit,

When you executed,did your script Loaded successfully?

if yes how did you check if data is present or not?

Regards

Neetha

Re: data in Database table but not in qlikview table

Wed, 26 Nov 2014 07:33:26 GMT

Hi Vinay,

How to check whether data is reloaded properly or not in your raw load.

Anyway I got the root cause of this issue. It was due to join.

Thanks all

Re: data in Database table but not in qlikview table

Anonymous — Wed, 26 Nov 2014 08:00:20 GMT

They are various ways to check if data is loaded or not one is going to table viewer(Ctrl + T).

Hover over tables and the info about loaded tables is displayed.

You need to check for:

Check for Information Density and Subset Ratio(hovering on tables in Table viewer(Ctrl + T)

Check whether dimension fields have 100% information density

Here is a good post from deepak to check Qlikview Application:

6 ways to Test your QlikView application

Regards

Neetha