4 Replies Latest reply: Aug 18, 2012 9:47 AM by Sebastian Pereira RSS

    Values Overlapping on Chart

      Is it possible to put chart values beneath the trendline on a line graph?

       

      I have an issue with values on a chart overlapping with one another (see attached screenshot). The overlapping data values complicate interpretation. Is there any way to format the chart so this wasn't an issue?

        • Re: Values Overlapping on Chart
          Advait Thakur

          Hello Nick,

          I have been through with the same thing. Unfortunately we do not have control over it. As you can see, its all about the data, both the lines are falling into same data points. At such point how qlikview will interpret. Also there is no formatting you can do.

           

          What I can suggest you is that- Keep Text as Pop Up. (Chart Properties> Expression Tab)

          This  is the only alternative. (Hope this will meet your end user requirement)

           

           

          Thanks,

          Advait

          • Re: Values Overlapping on Chart

            Hi Nick

             

            You can achieve this with a workaround, if you are willing. I use a seperate expression which I set to be an arbitrary value below the first expression, with a white line colour to fake the values below the other values. EG

            expr1: first expression = sales

            expr2: dummy expression. This is something like

            =[expr1] - 300

            =[expr1] - max(total sales)*0.1      --so it is in proportion to the highest amount of sales in the chart

             

            Edit the line colour for expr2  in the expressions list as "=white()" to make it invisible and then tick "values on datapoints" under the display options.

             

            Remember to uncheck the values on datapoints for expr1.

             

            Hope this is a satisfactory solution for you!

             

            Regards,

             

            Erica

            • Re: Values Overlapping on Chart
              Sebastian Pereira

              Hi nick, try to assign to one expression, "Text on Axis" (In expression tab). It will put the value under the axis.

               

              Anyway, the Erica solution i think is better.