Creating QVD

[#1]

Hello everyone.

I need help. I can't troubleshoot this any further.

I pull in 10 tables from my database.

CostItems.UserDefined1, thru, 10.

UserDefined1 has a value stored of $8,000, on one of it's many many rows, everything else is null until I add a value.

___________________________________

I run my script.

QUALIFY *;

CostItems:

     CostItems.UserDefined1,

     CostItems.UserDefined2,

     CostItems.UserDefined3,

     CostItems.UserDefined4,

     CostItems.UserDefined5,

     CostItems.UserDefined6,

     CostItems.UserDefined7,

     CostItems.UserDefined8,

     CostItems.UserDefined9,

     CostItems.UserDefined10

FROM dbo.CostItems;

UNQUALIFY*;

store CostItems into C:\UserDefined.qvd;

__________________________________

Back in QlikView, I create a column, 'UserDefined1', and $8,000 is spread across every row.

Even though, $8,000 is just in one row of the 'UserDefined1' column.

__________________________________

Similarly, this happens almost everytime I create a QVD.

I really need to figure this out.

Thank you in advance.

-A

EDIT:::::

Yes! Thank you for replying.

The first attachment 'Current.qvw' is the user interface I'm trying to integrate these fields into.

The second attachment 'UserDefined.qvw' is practically what I used to create the qvd.

I got mad yesterday and deleted the original, but it's pretty much the same.

EDIT:::::

I might as well add the QVD huh? And the QVS? Might as well. I'd really appreciate critique on all of the files, if I'm doing anything wrong elsewhere.

[#2]

Can you attach the test file you are working with?

Are you creating a table box object to verify data integrity for the fields?

[#3]

I've posted all of the files. Any assistance is greatly appreciated.

[#4]

I can't give up, someone has an answer for me, anyone? *crickets

[#5]

I'm trying to understand here.

All your files look good. CostItems table in the main application (Current.qvw) is an island table and is not linked to any of the dimensions in the pivot table. Therefore, it would show the single value in all rows.

Also, i checked your QVD. It has 339 rows with only 1 $8000 value on rowno 310. (Which is supposedly what you need - correct me if i'm worng)

[#6]

Jesus this post got knocked out.

That's the thing though it is linked.

There should be a value for that field in each row.

There are cost items, and there should be null, or a value, next to each cost item in the current.qvw.

So what am I doing wrong then?

[#7]

You need to link it to the main data model via an appropriate key.

[#8]

Can it be any key? As long as it links back to the data model?