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

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

Sandra_Cruz — Wed, 25 Nov 2020 16:16:04 GMT

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.

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

sergio0592 — Fri, 10 May 2019 08:53:51 GMT

Hi,

Can you share a sample of your issue?

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

Sandra_Cruz — Fri, 10 May 2019 16:03:54 GMT

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.

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

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

Thanks!!

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

Sandra_Cruz — Fri, 10 May 2019 16:09:00 GMT

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.

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

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

Thanks!!

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

sergio0592 — Tue, 14 May 2019 09:25:15 GMT

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?

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

Sandra_Cruz — Fri, 17 May 2019 16:49:27 GMT

Hi,

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

Thanks!!