topic Re: Garbage value from QVD in QlikView

Garbage value from QVD

Wed, 19 Dec 2012 11:16:31 GMT

Hi ,

I am pulling data from oracle database and then storing it in a qvd .

but when i try to pull the data from qvd and display it in a table box on frontend it gives us garbage value.

The data in QVd is simple select sttement based on grouping.

Thanks

Medha

Re: Garbage value from QVD

er_mohit — Wed, 19 Dec 2012 11:22:01 GMT

when you reload the files then expression seems like ok or not?

Re: Garbage value from QVD

Wed, 19 Dec 2012 11:31:30 GMT

What is the syntax do u used to store the data to qvd?

Is qvd has data or not?

How much rows load from that qvd while loading the application?

Re: Garbage value from QVD

Wed, 19 Dec 2012 14:11:57 GMT

load * from [path\mtd.qvd]; to load the data from qvd

lines loaded are 300-400

data is loaded to the QVD but its is Garbage value

store MTDcodes into [pathl\qvd\mtd.qvd].(qvd);

Re: Garbage value from QVD

er_mohit — Thu, 20 Dec 2012 05:55:15 GMT

try to use load through inline function for doing this data must be shown if it data show then something problem occured in loading otherwise there's mistake while store in qvd.

load * inline[

];

hope it will helps you

Re: Garbage value from QVD

Thu, 20 Dec 2012 09:03:10 GMT

Thanks , the problem is resolved now

Re: Garbage value from QVD

er_mohit — Thu, 20 Dec 2012 09:09:41 GMT

if it might be hlopful for you then mark it as either helpful or correct answer.for doing this it wouldmight be helpful for lot of developers.