Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Managing different granularity keys in Fact Table with generic key (?)

I have 2 dimensions, OperatingCompany and Company, merged with a JOIN into just the Company dimension, where an OperatingCompany manages 1 or several Companies.

Most metrics in the Fact table are by Company but one metric is by OperatingCompany.


How should I implement the Company Dimension so that when I only choose the OperatingCountry on screen I obtain all the OperatingCompany metrics?


Should I add to OperatingCompany/Company extra UID/records corresponding to OperatingCompany without Company? Would this work?


To complicate matters a client dimension connects to the fact table by Company.


Would this be a case where a "generic key" could be a solution? And how could it be implemented in the Company dimension?


Thanks

Tags (2)
2 Replies
Highlighted

Re: Managing different granularity keys in Fact Table with generic key (?)

I think you can use conditional dimensions/expressions.

You can learn more about "Conditional" feature (available since QlikView 11) in the "Whats New in QlikView11.qvw" sample document (see "Report" tab).

This feature allows you to show a chart containing only dimensions and expressions according with specific selections.

Highlighted
Not applicable

Re: Managing different granularity keys in Fact Table with generic key (?)

I'll check them out. Thanks