Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

BarbCline
New 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
Valued Contributor II

Re: conditional pop-up text

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
Valued Contributor II

Re: conditional pop-up text

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

BarbCline
New Contributor III

Re: conditional pop-up text

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

Re: conditional pop-up text

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