Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

marcoyukon
Contributor

Conformed Dimension in Qlik

How one can implement a dimension that is referenced more than one time in the model ? Example: Table Claim, Fields InsId1 and InsId2, linked to to Table Insurance by InsId. If I use only one insurance dim table I end up with a synthetic key created (not desired). If I duplicate the Ins Dim, my selections on insurance would be one for EACH  Insurance.Name. Thanks

2 Replies

Re: Conformed Dimension in Qlik

I think the correct data model would have one table for Claims, one table for Insurances and one table that contains the many-to-many relationship of Claims to Insurances:

Claim - Insurance

12345     Ins1

12345     Ins2

This way, you won't have any synthetic tables and you will only have one instance of each Insurance in the master Table.

Cheers,

Oleg Troyansky

Upgrade your Qlik skills with my book QlikView Your Business: An Expert Guide to Business Discovery with QlikView and Qlik Sense

mov
Esteemed Contributor III

Re: Conformed Dimension in Qlik

Not quite clear, trying to guess...

So, there are claims, and there are insurances, and I assume it could be Primary and Secondary insurance, hence InsId1 and InsId2.  If my guess is correct, I'd use only one InsId in the Insurance table, only ClaimId in the Claim table, and a table in between to connect these, call it for example Claim_Insurance, with the fields:

InsId (link to Insurance)

ClaimId (link to Claim)

InsType (Primary or Secondary)

If I didn't guess right, provide more info please.

Community Browser