topic Re: mouseover label in QlikView

mouseover label

Wed, 19 Jun 2013 06:29:43 GMT

Hello,

Is it possible to change my mouseover information?

Eg if i set my mouse over a bar in a barchart it will show me the whole expression and value. Is it possible to change this so i can make my own text or reduce to only show the value?

Kind regards

Re: mouseover label

Wed, 19 Jun 2013 08:34:49 GMT

Short answer is Yes, this is possible, but the solution is a little convoluted.

1. In the presentations tab of your chart, switch off Pop-up Labels

2. In the expressions tab of your chart, make sure that Text as Pop-up is un-checked

3. Add in a new expression, this one should have Text as Pop-up switched on but it should also have Bar/Symbol/Line un-checked so it doesn't appear as a new bar on the chart. You can basically put anything you like in here but just as an example, this is what I might do if I have a dimension called Region and 3 expressions called Sales/Cost/Profit:

='-----------------------------------------------------------' & chr(10) &

'Region = ' & [Region] & chr(10) &

'Sales Value = ' & [Sales] & chr(10) &

'Cost Value = ' & [Cost] & chr(10) &

'Profit = ' & [Profit] & chr(10) &

'-------------------------------------------------------------'

Obviously in the above example I'm using column names rather than actual expressions, but there's no reason why you can't just use expressions in here, including expressions that are not included in the chart at all (in the above example you might also want to include Profit as % of Sales).

This gives you a nice little pop-up that the user can read very easily.

Cheers,

Nigel.

Re: mouseover label

marc_behrens — Tue, 04 Feb 2014 10:16:44 GMT

Thanks for the info Nigel,

a little Addition:

I had a little "problem", when I selected a dimension value, in this case "Region". Other expression were hidden (f.e. bars), but the dimension values were still displayed.

I added the following and it worked:

If(IsNull(Region), Null(),

'-----------------------------------------------------------' & chr(10) &

'Region = ' & [Region] & chr(10) &

'Sales Value = ' & [Sales] & chr(10) &

'Cost Value = ' & [Cost] & chr(10) &

'Profit = ' & [Profit] & chr(10) &

'-------------------------------------------------------------'

)

Kind regards,

Marc

Re: mouseover label

Thu, 20 Mar 2014 15:12:35 GMT

Thanks a lot for this answer. Works like a charm.

However for some reason changing the number format for this expression doesn't work. Does anyone know how the change this? I

Re: mouseover label

Fri, 09 Jan 2015 14:28:56 GMT

Hi,

I'm trying to apply this same concept to a scatter chart. It works, however I can't untick 'bar' or 'line' for my new 'Text as pop-up' expression type, so it changes the look of my two visible expressions.

Ideas on what may be causing this?

Thanks for your help.

Re: mouseover label

Wed, 16 Dec 2015 10:26:29 GMT

May i know how is it possible in QlikSense??

Re: mouseover label

Tue, 29 Mar 2016 08:55:09 GMT

Works well but if you have more than one bar chart how do you handle it then?

Re: mouseover label

timanshu — Fri, 29 Sep 2017 08:54:38 GMT

Can Anyone give me the same solution for line chart. I can see the custom text as popup in bar chart but not in line chart. I am trying to convert the same chart from bar to line