topic Data granularity issue in QlikView

Data granularity issue

Anonymous — Sun, 29 Apr 2018 15:13:45 GMT

Hi Guru's

I have 4 Tables

Table 1:

Business Unit

Date,

Chart of account name,

Code Combination ID

Table 2:

Business Unit

Date,

Chart of account name,

Code Combination ID

Table 3:

Business Unit

Date,

Chart of account name,

Code Combination ID

where as the 4th Table ,data is on Month year wise Account balance

Table 4:

Business Unit

Period name---Date field name with MMM-YY Format

Chart of account name,

Code Combination ID

Account balance

First 3 tables are concatenated and join with Master calendar

Now i want to add 4th table to existing concatenated data model to bring in Business Unit wise ,Year,Month wise Account balance.

How to achieve this with out changing concatenated data model

Thanks,

Rajiv