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: 
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
Master II
Master II

Can you post your code?

Not applicable
Author

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
Author

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
Author

 

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
Author

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

Not applicable
Author

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.