Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Concatenation of qvd-load #fail

Hi,

I have a strange behavior in QV10 SR3.

When loading my QVD-file into a testing app I get 10 rows (as expected), but when I load it in the actual app I get 150 rows. Same rows 15 times so when I do the math I get wrong numbers.

Guessing that it's concatenating the qvd 15 times but I dont see any reason for it to do that. No loop or anything.

Any Ideas?

regards

thomas

6 Replies
danielrozental
Honored Contributor II

Re: Concatenation of qvd-load #fail

Can you post your code?

Not applicable

Re: Concatenation of qvd-load #fail

sounds like a join problem to me.

you have the exact same tables in the test app and in the actual app?

if yes attach a sample so we can check. 

thnks

Not applicable

Re: Concatenation of qvd-load #fail

you can separate the data from this file QVD and check how many rows is being returned?

Maybe in your application is being created any link with any table through key fields.

Not applicable

Re: Concatenation of qvd-load #fail

 

butik:

LOAD TransDatum,

     Merchant,

     Location,

     Location_stopped,

     Merchant_stopped,

     Location_created,

     Merchant_created,

     Location_I,

     Location_stopped_I

FROM

Config\QVD\hist_butik.qvd

(qvd);

 

Not applicable

Re: Concatenation of qvd-load #fail

Noconcatenate Load creates butik with 140 rows and butik-1 with 10 rows...

Not applicable

Re: Concatenation of qvd-load #fail

Hi,

do you can post the script file of your qlikview document?

I think that more tables return the some number of fields and the automatic concatenate with others tables.

Please post all script file, not part of the code.

Community Browser