topic Re: Key Mapping issue between two table in Qlik Sense in App Development

Key Mapping issue between two table in Qlik Sense

iahmad9 — Thu, 04 Jul 2024 16:44:03 GMT

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

Re: Key Mapping issue between two table in Qlik Sense

marksouzacosta — Thu, 04 Jul 2024 22:31:06 GMT

Do you need the '_Bond" Derived_Acc_Id accounts?

Re: Key Mapping issue between two table in Qlik Sense

Vegar — Fri, 05 Jul 2024 04:41:37 GMT

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.

Re: Key Mapping issue between two table in Qlik Sense

iahmad9 — Fri, 05 Jul 2024 04:50:29 GMT

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

Re: Key Mapping issue between two table in Qlik Sense

iahmad9 — Fri, 05 Jul 2024 04:56:03 GMT

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

Re: Key Mapping issue between two table in Qlik Sense

iahmad9 — Fri, 05 Jul 2024 09:35:31 GMT

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

Re: Key Mapping issue between two table in Qlik Sense

marksouzacosta — Fri, 05 Jul 2024 21:12:17 GMT

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?

Re: Key Mapping issue between two table in Qlik Sense

iahmad9 — Sat, 06 Jul 2024 14:36:26 GMT

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