topic Re: two fact tables in QlikView

two fact tables

upaliwije — Wed, 13 May 2015 22:01:11 GMT

Dear Friends

I have two fact tables with following fields

table 1

Dept,class,premium

table 2

Dept,Class,Vehicle Type, Claim Paid

When I concatenate two tables in my data model I m unable to extract a chart(straight Table) in following format

Vehicle Type,Premium,Claim Paid (premium data shows zero value)

That is because vehicle type field does not exists in table1.

Can someone please tell how to do this

Anonymous — Wed, 13 May 2015 22:43:24 GMT

Load a NULL value into a new field [Vehicle Type] in table one.

Here's an example:

concat_table:

load

null() as [Vehicle Type]

resident table1

load

resident table2

Anonymous — Wed, 13 May 2015 22:50:39 GMT

I guess you need join rather than concatenate.

Please rename class field so it is Class in both tables. Fields "class" and "Class" are different.

Anonymous — Wed, 13 May 2015 22:55:36 GMT

Michael,

You're right. I didn't read the problem carefully enough. My solution wouldn't accomplish what Upali needed.

Brian