Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
liamlucas
Contributor II
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
Partner - Specialist
Partner - Specialist

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