topic Combo chart tooltip dupes in QlikView

Combo chart tooltip dupes

richnorris — Thu, 25 Mar 2010 11:37:35 GMT

Hi,

I've got a combo chart that has both bars and symbols. I've got 'show text as popup' for the expressions, however it appears that where a symbol rests on top of a bar, if you hover over it, it shows the expressions in the tooltip twice. I'm guessing its showing the text popup for the symbol and then for the bar. I don't want to remove the popup from either, because they don't always overlap, but I dont want it to show the expressions twice. Is there a way to give the symbols precedence somehow?

Thanks in advance!

Combo chart tooltip dupes

Thu, 25 Mar 2010 12:41:39 GMT

I find the tool tips stuff in QlikView particularly difficult to control, however, I stumbled across the following solution which, although laborious, works really well for me and the end-users. The picture below shows the end result of the tool tip:

The process to get to this point is as follows:

In the presentation tab, switch off Pop-up Labels.
In the expressions tab, switch off Text as Pop-up on ALL expressions.
Create a new expression called Tool Tip, this one should have Text as Pop-up switched on, you should also switch OFF all of Bar, Symbol, Line, Stock, Box Plot.

The formula that I have used for the new expression is as follows (but you can obviously use whatever format works for you):

'~~~~~~~~~~~~~~~~~~~~~~~~~~~~'
 & chr(13) & 'Date : ' & Date(DT_TransQuarterEnd,'DD-MMM-YY')
 & chr(13) & 'Cost : ' & Num(Column(1),vNumberFormat)
 & chr(13) & 'Distribution : ' & Num(Column(2),vNumberFormat)
 & chr(13) & 'Dist + FMV : ' & Num(Column(3),vNumberFormat)
 & chr(13) & 'Invested Capital : ' & Num(Column(4),vNumberFormat)
 & chr(13) & '~~~~~~~~~~~~~~~~~~~~~~~~~~~~'

Hope it helps,

Combo chart tooltip dupes

richnorris — Thu, 25 Mar 2010 15:19:33 GMT

Ah, thats quite clever! I guess it means you lose the 'swelling focus' when you highlight a symbol or line, but its a fair trade off for managable popups. Thanks a lot for that!

Combo chart tooltip dupes

Thu, 25 Mar 2010 15:34:34 GMT

Actually you don't lose the swelling/focus on symbole and/or lines, what happens though is that no matter which line you put the focus on, the pop-up will be the same, for me that's ok because the pop-up contains all of the values.

Good luck,

Combo chart tooltip dupes

richnorris — Thu, 25 Mar 2010 15:40:20 GMT

Oh! well, all the better!