topic Re: Resolve Synthetic Keys with 8 Categories of Same Metrics in QlikView

Resolve Synthetic Keys with 8 Categories of Same Metrics

Wed, 25 Nov 2020 16:16:04 GMT

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.

Dimension(s):
- FTE
- GSO-ON
- GSO-OFF
- Budget
- Objectives
- Deliverables
Metric(s):
- Year
- Maturity State
- Maturity Index
- Budget Type
- Budget Nature
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,

Re: Resolve Synthetic Keys with 8 Categories of Same Metrics

rupamjyotidas — Mon, 26 Jun 2017 19:37:26 GMT

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

Re: Resolve Synthetic Keys with 8 Categories of Same Metrics

Mon, 26 Jun 2017 19:42:38 GMT

Rupam,

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

Re: Resolve Synthetic Keys with 8 Categories of Same Metrics

rupamjyotidas — Mon, 26 Jun 2017 19:46:38 GMT

Load

'ABC' as Business Flag

From XYZ where business='ABC'

Concatenate

Load

'FGH' as Business Flag

From ZYX where business='FGH'

Re: Resolve Synthetic Keys with 8 Categories of Same Metrics

rupamjyotidas — Mon, 26 Jun 2017 19:50:26 GMT

Avoid Duplicate thread plz

Resolve Synthetic Keys