Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Sandra_Cruz
New 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
Valued Contributor II

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

Hi,

Can you share a sample of your issue?

Sandra_Cruz
New Contributor

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

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

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

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!!

Tags (1)
sergio0592
Valued Contributor II

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

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

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

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!!