topic Re: Two data sets, common field, same values, different logic in QlikView

Two data sets, common field, same values, different logic

Thu, 16 Oct 2014 12:28:33 GMT

Hi!

I have built a star schema data model for a requirement currently am working on.
In the fact table, there’s a Income Statement allocation logic and a Balance Sheet distribution logic against various branches. Since both of them are different, it resulted in two branch fields(IS_BRANCH and BS_BRANCH). And in all the records, there are different branch names under both, but not always.

Now, how to unify branch selection across the dashboard, i.e, if I select Branch 1, then both the reports should become for Branch 1.

Any ideas,suggestions shall help!

Thanks,

-KR

Re: Two data sets, common field, same values, different logic

Thu, 16 Oct 2014 12:44:57 GMT

Hi,

are both field in the same table?

Re: Two data sets, common field, same values, different logic

MK_QSL — Thu, 16 Oct 2014 12:49:37 GMT

Something like below...

Country:

Load PCountry as Country, PCountry Resident P;

Load SCountry as Country, SCountry Resident S;

Table1:

Load Field11, Field12, IS_BRANCH From TableName;

Table2:

Load Field21, Field22, BS_Branch From TableName;

Branch:

Load IS_Branch, IS_Branch as Branch Resident Table1;

Load BS_Branch, BS_Branch as Branch Resident Table2;

Now Use Branch as a List BOX

Re: Two data sets, common field, same values, different logic

Thu, 16 Oct 2014 12:52:19 GMT

Hi Knight,

I would load the table twice, once for IS only and again for BS (concatenate the two) and unify the different branch fieldnames into a common branch field.

It is worth saying you should create a data/branch source type field when doing this load (label IS and BS respectively), so that you can easily limit to one of the other via a field selection

hope that helps

Joe

Re: Two data sets, common field, same values, different logic

Thu, 16 Oct 2014 13:05:18 GMT

Hi Shruthi,

Yes, both are the in the same table...

-KR