topic Re: Data Shows In SQL But Not Qlikview in QlikView

Data Shows In SQL But Not Qlikview

Tue, 04 Nov 2014 14:27:33 GMT

Hi folks,

Has anyone seen an issue where the Qlikview dataset does not match what is returned in SQL.

I'm getting some strange stuff like 300 records in SQL being returned, but when displaying the same query (a view) in Qlikview it may only return 20 records etc. If I do a search for one of the missing records using a search box, it then shows up.

So everything is returning in SQL Management studio, and if I search for a missing record in a searchbox it shows up then.

Not sure if it's something with NULL values or column names or along those lines?

Thanks

Re: Data Shows In SQL But Not Qlikview

Tue, 04 Nov 2014 14:51:14 GMT

Hi,

If the records contains duplicates it will stor it as a single record only.please check the data once.

Re: Data Shows In SQL But Not Qlikview

Tue, 04 Nov 2014 14:56:50 GMT

Hi there,

Thanks for the reply.

I've checked and this doesn't seem to be the cause as far as I can see. I have a person record showing in the SQL query, but they don't show at all in Qlikview.

I noticed that when I do 'Search' in Qlikview for the person, and they then show up, their Person ID column has the green light in it (which the others don't). Do you know how to unlink sheets. This may be causing the issue perhaps?

Re: Data Shows In SQL But Not Qlikview

Tue, 04 Nov 2014 15:00:16 GMT

if u have 2 duplicate records then u will get only one record.

and some times there is a limitation of showing data also pls check it

Re: Data Shows In SQL But Not Qlikview

Tue, 04 Nov 2014 15:02:22 GMT

Thanks. I don't have a duplicate record for the person. They show once in SQL, but not at all in Qlikview unless I do a search for them.

Do you know how to unlink the sheets/tabs so that the little green light is removed? I think the link might be causing the issue for some reason and would like to test.

Re: Data Shows In SQL But Not Qlikview

Tue, 04 Nov 2014 15:07:28 GMT

unlink means what u want to do here , can u come up with little bit more

Re: Data Shows In SQL But Not Qlikview

Tue, 04 Nov 2014 15:10:24 GMT

I would like to try and detach the sheets...so if I make a change on one sheet, it doesn't effect any data on another sheet. In other words, there won't be the green lights linking the sheets...

Can you tell me how to do this?

Re: Data Shows In SQL But Not Qlikview

gandalfgray — Tue, 04 Nov 2014 15:39:14 GMT

It's a bit against the principles of QlikView, but you can use the Qualify statement to "unlink" fields that otherwise would have the same name.

ie if you have two tables that normally would link on "order_id"

you can write

Qualify order_id;

before loading any of the tables.

In your case you need two know which fileds acts as links, or you can write

Qualify *;

Search the documentation for "Qualify"