Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
BarbCline
Contributor III
Contributor III

conditional pop-up text

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)))

 

1 Solution

Accepted Solutions
sergio0592
Specialist III
Specialist III

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?

View solution in original post

3 Replies
sergio0592
Specialist III
Specialist III

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
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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