Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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?

1 Solution

Accepted Solutions
Not applicable

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

4 Replies
advait_thakur
Contributor III

Re: Values Overlapping on Chart

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

Not applicable

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

Not applicable

Re: Values Overlapping on Chart

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

sebastiandperei
Valued Contributor

Re: Values Overlapping on Chart

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.

Community Browser