conditional pop-up text

[BarbCline]

Hello!  I have a combo box chart with several expressions.  I've added another expression as pop-up text to show membership.  Right now it shows the same number regardless of which expression I hover over.  But, I would like to conditionally provide the membership that pertains to each expression.  Is there a way to evaluate for each expression?  When I refer to the other expression labels, it's not working as I expected  Please see screen shot examples.

I've tried this for the pop-up expression, but 5 is the result for every expression pop up.

=If(Exp1, 'Members = ' & 5,
If(Exp2, 'Members = ' & 10,
'Members = ' & sum(Members)))

[sergio0592 · Accepted solution]

Hi, i think you don't have to use "Text as pop-up" for the expression. Use instead dual () function for Exp1 and Exp2. See the attached .qvw.

In my sample, exp1 is sum(sales)*2 and exp2 is sum(sales)

Is it what you're trying to achieve?

[BarbCline]

Thanks for the quick response!  I spent more time reviewing your QVW example and this is exactly what I want.  My original object is being quirky and not working when I add the dual statement, which had be side-tracked for awhile.  I've now copied your object and tailored it to meet my needs.  Thank you!! 

[BarbCline]

Just a note to anyone trying to apply this solution ... at first I couldn't get this to work in my chart, because I had a number format setting on the expression.  I had to change it to "Expression Default" for the dual function to work.  Just sharing to avoid a headache or two