Qlik Community

Qlik Sense App Development

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

New Contributor II

Alternating expression

I want to create a master measure and use it in two different pivot tables.  If I am looking at  Pivot table 1 the first if statement will be active but if I am looking at Pivot table 2 the second if statement will be active.  I was thinking this might be possible if I referenced each pivot table object id.  Can you help?

If(Obj=ZQhUiW, [Liability] + [Equity],
If(Obj=BClJoL, [Revenue] - [Expenses]))

1 Reply
Contributor III

Re: Alternating expression

Hi Liam

Why do you want to use the same master measure twice? Can't you just create two and give them different names and the same label?