topic Values Overlapping on Chart in QlikView

Values Overlapping on Chart

Fri, 20 Nov 2020 18:02:30 GMT

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 — Fri, 10 Aug 2012 04:33:39 GMT

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

Sat, 18 Aug 2012 07:39:49 GMT

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

Sat, 18 Aug 2012 07:43:50 GMT

BTW you could also set expr2 to only show datapoints when expr1 overlaps the other expression.

You could achieve this in an if() statement. EG if(expr2012 - expr2011 >= 10,.....)

Regards,

Erica

Re: Values Overlapping on Chart

sebastiandperei — Sat, 18 Aug 2012 13:47:07 GMT

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.