topic Re: Creating QVD in QlikView

Creating QVD

Wed, 07 Mar 2012 23:11:54 GMT

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.

Creating QVD

Thu, 08 Mar 2012 04:04:00 GMT

Can you attach the test file you are working with?

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

Creating QVD

Thu, 08 Mar 2012 16:59:05 GMT

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

Creating QVD

Thu, 08 Mar 2012 22:41:55 GMT

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

Re: Creating QVD

Fri, 09 Mar 2012 02:34:41 GMT

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)

Creating QVD

Mon, 12 Mar 2012 19:15:41 GMT

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?

Re: Creating QVD

Mon, 12 Mar 2012 19:27:29 GMT

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

Creating QVD

Mon, 19 Mar 2012 15:55:30 GMT

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