Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Merging tables with different levels of detail

I get my data at a Division level earliest every quarter, for all income statement accounts.

Year Quarter Division Written Premium Earned Premium Losses
2010                 1 North America                           20,000                          18,000    10,800
2010                 1 Europe                           12,000                          12,000      8,400
2010                 1 Asia                           15,000                          10,000      6,500

Then, a week later I get my data for Written Premium only broken out by country, which I can map to a division.

Year Quarter Country Written Premium
2010                 1 USA                           14,000
2010                 1 Mexico                              2,000
2010                 1 Canada                              4,000
2010                 1 London                              8,000
2010                 1 Ireland                              4,000
2010                 1 Singapore                           15,000

Country Division
USA North America
Mexico North America
Canada North America
London Europe
Ireland Europe
Germany Europe
Japan Asia
Egypt North Africa


So I'd like to have my one income statement account be able to drill down, or have charts showing it by country.. and every other income statement account shown by division.  An added layer is that I have Forecast data by Country and Division.. but that is for another day.  How should I set up my tables to not have synthetic keys?  I'd like to add that waiting for the by Country data for Written premium isn't an option.  Thanks for any help.

1 Solution

Accepted Solutions
nagaiank
Valued Contributor III

Re: Merging tables with different levels of detail

Here is a slightly modified version of the solution proposed by Carlos Reyes, giving the correct totals.

2 Replies
Not applicable

Re: Merging tables with different levels of detail

Is this what you want?

nagaiank
Valued Contributor III

Re: Merging tables with different levels of detail

Here is a slightly modified version of the solution proposed by Carlos Reyes, giving the correct totals.