6 Replies Latest reply: Mar 29, 2016 4:55 AM by Andre Toerien RSS

    mouseover label

      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

          Hi

           

          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

              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

                  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.

                   

                  M

                • Re: mouseover label
                  Andre Toerien

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

                • Re: mouseover label

                  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

                    May i know how is it possible in QlikSense??