Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Honored Contributor

Scatter Plot

In scatter plot, i have 1 dimension and 3 expressions. 3 expression is for the size of the bubble and is conditional.

Now on hover over bubble, it is showing all the 3 expression values.

I want to hide 3rd expression value on hover, can anyone help on this?

14 Replies
Highlighted

Re: Scatter Plot

Better to provide sample application.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Honored Contributor

Re: Scatter Plot

Attached...plz check

Highlighted

Re: Scatter Plot

PFA

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Honored Contributor

Re: Scatter Plot

Hi, my QV license is expired, can you tell what you changed?

Highlighted
Honored Contributor

Re: Scatter Plot

Screenshots plz?

Highlighted

Re: Scatter Plot

UN-Check the popup from presentation tab. And then use these expressions?

1) Dual('Sum = ' & Sum(Salary), Salary)

2) Dual('Average = ' & Sum(Salary)/Count(Salary),Sum(Salary)/Count(Salary))

3) Dual('',Salary)

Note - Please enable popup labels in expression for first two metrics then mouse over in your bubbles.

Capture.PNG

Or alternatively we can simple change 3rd expression. But here you can't rid equal sign if we go second approach, So follow first approach

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Honored Contributor

Re: Scatter Plot

But then dimension will not be shown, Name has to be there in hover.It's mandatory

please show that also

Highlighted

Re: Scatter Plot

That's why I've clearly initiate for you in second approach. But, Looks it's not good.

Third Approach, May be create calculate dimension like

=aggr(Name & ' : ' & sum(Salary), Name)


Note - This dimension can show in legend it self rather popup and you can explain same with customer to convey them as these are the limitation  in qlikview.

Capture.PNG

Please mark as helpful and flag correct answer if it applicable your needs.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Honored Contributor

Re: Scatter Plot

Yeah but in QV11, 3rd expression was not coming in hover but after QV12 it is coming without any change in scripting.

That's i am asking to hide 3rd expression without hiding dimension in Hover.

Dimension has to be there in hover except 3rd expression.

It is happening post upgrade in QV12