Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Sandra_Cruz
Contributor
Contributor

Query in database don't show the same in the qlickview

Hi everyone,

I was wondering if anyone would be able to help me.  Currently, I have a problem when I make a select to  product , but it show different in the qlickview.

In the  database exists two products (S503004) Y (503004), when I do the query in oracle it show the correct answer related with the number of document, but in qlickview  when I search the documents it show only  (S503004)    , so i can't 

find the correct (503004). I don't Inderstand why it show different.

Any help would be greatly appreciated.

Many thanks.

5 Replies
sergio0592
Specialist III
Specialist III

Hi,

Can you share a sample of your issue?

Sandra_Cruz
Contributor
Contributor
Author

Sure, 

I had a problem to show the data in the qlickview but only it happen with a product, for example, I do a simple query in the qlickview.

Captura.PNG

When I search the document in the qlickview, it show the product as (S503004)

Captura2.PNG

But in the database is other without the letter S. It only happen with that product.

Captura3.PNG

Thanks!!

Sandra_Cruz
Contributor
Contributor
Author

Sure, 

I had a problem to show the data in the qlickview but only it happen with a product, for example, I do a simple query in the qlickview.

Captura.PNG

When I search the document in the qlickview, it show the product as (S503004)

Captura2.PNG

But in the database is other without the letter S. It only happen with that product.

Captura3.PNG

Thanks!!

sergio0592
Specialist III
Specialist III

Hi,

So it's not a QlikView problem, it's a problem in your SQL tool parameters. He is unable to display S, what is the type of your field in your Oracle/MySQL/SQL Server table?

Sandra_Cruz
Contributor
Contributor
Author

Hi,

I thought the same, but when I display the report of my database in oracle , it export correctly with the letter  S.

Captura.PNG

Thanks!!