Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Resolve Synthetic Keys with 8 Categories of Same Metrics

Hello,

I'm struggling to figure out how to resolve a synthetic key issue. The context of this issue is that I'm attempting to create a dynamic pivot table with the following selection options as list boxes. I figured out how to achieve the list boxes, but I can't figure out how to populate the dynamic pivot.

  1. Dimension(s):
    • FTE
    • GSO-ON
    • GSO-OFF
    • Budget
    • Objectives
    • Deliverables
  2. Metric(s):
    • Year
    • Maturity State
    • Maturity Index
    • Budget Type
    • Budget Nature
  3. Business Area(s):
    • Dev Ops
    • Prod Ops
    • 3PD
    • TDM

My main issue is that all of the business areas share the same metrics & dimensions. Thus, my entire table is connected by a number of synthetic keys. Here is the key view after I tried to resolve the issue by qualifying each table. However, that won't resolve my problem because I need to associate each dimension & metric between the 10 business areas.

Is anyone able to point me in the right direction? Do I need to create a link table, or concatenate the common dimensions & metrics (even though they are shared by all of the business areas)?

Best,

AR

4 Replies
rupamjyotidas
Specialist
Specialist

Concatenate all the business area into a single table with flag for each business area.

In your expression you can use the flag to determine which business area.

This would help

Customizable Straight Table

Not applicable
Author

Rupam,

Thanks for the response. Can you go into more detail regarding flags?

rupamjyotidas
Specialist
Specialist

Load

*,

'ABC' as Business Flag

From XYZ where business='ABC'

Concatenate

Load

*,

'FGH' as Business Flag

From ZYX where business='FGH'

rupamjyotidas
Specialist
Specialist

Avoid Duplicate thread plz

Resolve Synthetic Keys