Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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