Qlik Community

Qlik Sense App Development

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

liamlucas
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
Mauritz_SA
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?

Regards,

Mauritz