Data Shows In SQL But Not Qlikview

[#1]

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

[#2]

Hi,

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

[#3]

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?

[#4]

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

[#5]

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.

[#6]

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

[#7]

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?

[gandalfgray]

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"