Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
iahmad9
Partner - Contributor III
Partner - Contributor III

Key Mapping issue between two table in Qlik Sense

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

Labels (1)
7 Replies
marksouzacosta

Do you need the '_Bond" Derived_Acc_Id accounts?

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

Vegar
MVP
MVP

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
Partner - Contributor III
Partner - Contributor III
Author

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
Partner - Contributor III
Partner - Contributor III
Author

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
Partner - Contributor III
Partner - Contributor III
Author

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?

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

iahmad9
Partner - Contributor III
Partner - Contributor III
Author

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