topic Data points getting overlapped by Line chart in Qlikview in QlikView

Data points getting overlapped by Line chart in Qlikview

devarasu07 — Sat, 16 Nov 2024 02:44:16 GMT

Hi All,

I've a Line graph with three KPI metrics, the issue here is some the values are either getting overlapped by the Line itself or by the data value of another expression value.

Please suggest if any work around to solve this.

Please refer to the mock app with screenshot

Re: Data points getting overlapped by Line chart in Qlikview

sunny_talwar — Thu, 15 Aug 2019 11:38:31 GMT

I simplified your expression from 3 expressions to 2 expressions. Also, this is not perfect, but my solution is based on these two threads

Stopping values on data points overlapping

Values Overlapping on Chart

So, basically I created two new expressions for displaying the value

Dual(sum({$<Year={"$(=max(Year))"}>}SoldQty), sum({$<Year={"$(=max(Year))"}>}SoldQty) * 0.90)

Dual(sum({$<Year={"$(=max(Year)-1)"}>}SoldQty), sum({$<Year={"$(=max(Year)-1)"}>}SoldQty) * 1.1)

and both these lines are set with a background color of ARGB(0, 0, 0, 0). Also, removed 'Value on Data Points' for your actual expressions.

Re: Data points getting overlapped by Line chart in Qlikview

sunny_talwar — Thu, 15 Aug 2019 11:42:49 GMT

Jan didn't look right where 398 was lower than 354... changed the expressions to this for the display of numbers

Dual(RangeMin(sum({$<Year={"$(=max(Year))"}>}SoldQty), sum({$<Year={"$(=max(Year)-1)"}>}SoldQty)), sum({$<Year={"$(=max(Year))"}>}SoldQty) * 0.90)

and

Dual(RangeMax(sum({$<Year={"$(=max(Year))"}>}SoldQty), sum({$<Year={"$(=max(Year)-1)"}>}SoldQty)), sum({$<Year={"$(=max(Year)-1)"}>}SoldQty) * 1.1)