https://community.qlik.com/t5/App-Development/Alternating-expression/m-p/1568484#M41476 <P>I want to create a master measure and use it in two different pivot tables.&nbsp; If I am looking at&nbsp; 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.&nbsp; I was thinking this might be possible if I referenced each pivot table object id.&nbsp; Can you help?</P><P>If(Obj=ZQhUiW, [Liability] + [Equity],<BR />If(Obj=BClJoL, [Revenue] - [Expenses]))</P> Fri, 12 Apr 2019 03:44:46 GMT liamlucas 2019-04-12T03:44:46Z https://community.qlik.com/t5/App-Development/Alternating-expression/m-p/1568484#M41476 <P>I want to create a master measure and use it in two different pivot tables.&nbsp; If I am looking at&nbsp; 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.&nbsp; I was thinking this might be possible if I referenced each pivot table object id.&nbsp; Can you help?</P><P>If(Obj=ZQhUiW, [Liability] + [Equity],<BR />If(Obj=BClJoL, [Revenue] - [Expenses]))</P> Fri, 12 Apr 2019 03:44:46 GMT https://community.qlik.com/t5/App-Development/Alternating-expression/m-p/1568484#M41476 liamlucas 2019-04-12T03:44:46Z https://community.qlik.com/t5/App-Development/Alternating-expression/m-p/1568573#M41478 <P>Hi Liam</P><P>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?</P><P>Regards,</P><P>Mauritz</P> Fri, 12 Apr 2019 06:43:33 GMT https://community.qlik.com/t5/App-Development/Alternating-expression/m-p/1568573#M41478 Mauritz_SA 2019-04-12T06:43:33Z