Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

htdiepqlik
New Contributor

Turn off relation for specific measures

RelationshipOption.png

As snapshot above, I want to calculate 2 things:

(1) Number of Staff having orders in selected month

(2) Number of Staff existing in selected month

In order to do that, I have to set up circular relations between the 3 tables like above. When I calculate (1), I have to turn off the relation between [Calendar] and [Staff], when I calculate (2), I have to turn off relation between [Calendar] and [Order].

Is it possible to do so with Qlik Sense?

1 Reply

Re: Turn off relation for specific measures

Maybe simply removing the Month field from the Staff table could suffice.  It will still linked to the Calendar table via the Order table.

I would guess your Staff table has more columns in it like maybe the staff member's full name etc.... so you won't be able to simply delete the table.

Nevertheless you would end with a classic star schema with your Orders table being your central Fact table and Staff and Calendar tables being satellite dimension tables.

Community Browser