Key Mapping issue between two table in Qlik Sense

[iahmad9]

Hi Team,

I am facing some mapping issue in Qlik sense between two table. For instance, we have two table. 

Table A:(Daily data)

Derived_Acc_Id	Acc_Id	Date
Acc1_Loans	Acc1_Loans	06/30/2024
Acc1_Bonds	Acc1_Loans	06/30/2024
Acc2_Loans	Acc2_Loans	03/07/2024
Acc2_Bonds	Acc2_Loans	03/07/2024

Key column for Table A:

Acc_Id&Date(Date,'MM/DD/YYYY') as %Key,

Table B(Monthly data)

Acc_Id	Date
Acc1_Loans	06/30/2024

Key column for Table B:

Acc_Id&Date(Date,'MM/DD/YYYY') as %Key,

My problem is that Business user wants 'Derived_Acc_Id' on the dashboards. because there is more details.

First of sorry, i cannot share data all details due to data security. When i am  filtering the data using the  Acc_Id the Derived_Acc_Id data showing both(Acc1_Loans,Acc1_Bonds) but business user wants only one Acc_id shoud populate on the Derived_Acc_Id column which is(Acc1_Loans) .

I would like to request you please help on this. thank you in advanced.

Regards,

Irshad Ahmad

[marksouzacosta]

Do you need the '_Bond" Derived_Acc_Id accounts?

[Vegar]

What if you change the key definition in table A.

Derived_Acc_Id & Date(Date,'MM/DD/YYYY') as %Key

Then the association between the two will work according to stakeholder needs.

[iahmad9]

Hi Vegar,

Thank you for your response. I tried like this also but some of the Derived_Acc_Id not same match with Acc_Id that is a reason we are using Acc_Id&Date(Date,'MM/DD/YYYY') as %Key, for both table.

Regards,

Irshad Ahmad

[iahmad9]

Hi @marksouzacosta ,

In the Derived_Acc_Id we need '_Bond also but when we filter the Acc_Id ='Acc1_Loans' it shoud show loans only on Derived_Acc_Id but currently showing both .

Regards,

Irshad Ahmad

[iahmad9]

Hi @Vegar ,

Thank you for your time. When i am using the Derived_Acc_Id & Date(Date,'MM/DD/YYYY') as %Key

some the of the Acc_Id is not as same as Derived_Acc_Id that is a reasion we are using Acc_Id in both table.

Regards,

Irshad Ahmad

[marksouzacosta]

What if you create a new field to qualify the accounts (Loan, Bond, etc) and use that field to restrict the values processed by your measures with Set Analysis when needed?

[iahmad9]

Hi @marksouzacosta ,

Thank you for your valuable time to look into it 

It would be fine if we could do it on data model because in the table b. We have one column which is composite that will contains only Loans. Business user using this to filter the loans related information.

Regards,

Irshad Ahmad