topic Scatter Plot in QlikView

Scatter Plot

shiveshsingh — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Scatter Plot

Anil_Babu_Samineni — Sat, 04 Nov 2017 16:47:22 GMT

Better to provide sample application.

Re: Scatter Plot

shiveshsingh — Sun, 05 Nov 2017 06:27:30 GMT

Attached...plz check

Re: Scatter Plot

Anil_Babu_Samineni — Sun, 05 Nov 2017 06:54:15 GMT

PFA

Re: Scatter Plot

shiveshsingh — Sun, 05 Nov 2017 06:58:14 GMT

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

Re: Scatter Plot

shiveshsingh — Sun, 05 Nov 2017 06:58:58 GMT

Screenshots plz?

Re: Scatter Plot

Anil_Babu_Samineni — Sun, 05 Nov 2017 07:04:58 GMT

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.

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

Re: Scatter Plot

shiveshsingh — Sun, 05 Nov 2017 07:07:42 GMT

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

please show that also

Re: Scatter Plot

Anil_Babu_Samineni — Sun, 05 Nov 2017 07:28:26 GMT

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.

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

Re: Scatter Plot

shiveshsingh — Sun, 05 Nov 2017 07:43:20 GMT

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

Re: Scatter Plot

Anil_Babu_Samineni — Sun, 05 Nov 2017 11:04:45 GMT

You are in suffering stage, Every one already upgrade to QV12 because 11 support may be expired by Mar 2018. So, I would request your company please upgrade ASAP. And, In my variant 2nd approach is looks like this? As i state earlier the highlight one i can't rid may be you can play with that (Or others have some work around where i am not). And just change 3rd expression like mine 2 post back reply.

Re: Scatter Plot

shiveshsingh — Sun, 05 Nov 2017 16:37:20 GMT

Yeah that i know, qv11 support would end soon but this 3rd expression was not popping out in qv11 but don't know why it is coming in qv12, is it a fix in QV12? can u comment on this?

Re: Scatter Plot

Anil_Babu_Samineni — Sun, 05 Nov 2017 16:55:32 GMT

Are you talking about Equal sign prompt in QV12, If it is, not yet happened..

Re: Scatter Plot

shiveshsingh — Sun, 05 Nov 2017 17:02:24 GMT

Nopes, not equal sign but complete 3rd expression value.

The app that i shared with you doesn't show 3rd expression value in QV11 but show in QV12.

I am asking if this is some fix deployed in QV12?

Re: Scatter Plot

Anil_Babu_Samineni — Sun, 05 Nov 2017 17:14:21 GMT

Oh it it, That part i am not aware.

Conclusion - When we are not seeing something in QV11 and able to see that in QV12 may be team worked and fix that bug in a way. But, really not able to answer you due to i am just employee not the production manager / employee from Qliktech. We have few folks who works for Qliktech likehic‌