topic Re: Line Chart max year and min year behavior in QlikView

Line Chart max year and min year behavior

Barry-Gon — Fri, 15 Nov 2024 23:12:39 GMT

Hi,

I have a line chart with the given values. The chart works fine with two consecutive years, but

1) When I select 3 years the lower year and the highest year for some reason the values in the line chart have a funny behavior.
2) When I select the lowest and the highest years, the chart only shows the highest year

Correct chart

Three years (Wrong)

Max and Min years selected (Wrong)

Please help

@rubenmarin You helped me before, any advice?

Thanks in advance.

Re: Line Chart max year and min year behavior

edwin — Tue, 02 Feb 2021 21:30:26 GMT

You have a pretty complicated expression and its hard to say why it is returning the value it is returning wihout understanding the business rules.

to help point you to the rt direction, change your chart type to STRAIGHT TABLE you will see that for 2018 the expression is returning 0 for 2018. thats bec most of the main expressions return 0 for 2018. find out why its returning 0 and you might solve your problem hence you see just one line

Re: Line Chart max year and min year behavior

Barry-Gon — Tue, 02 Feb 2021 21:50:42 GMT

Thank you Edwin / Specialist II

The Table works fine, but when I change the view to Line Chart, for some reason the values are not display as the REAL column.

AmtUSD - Is the full accumulation of the month from the previous month
DaysOfMonth - Is the full accumulation of the number of dates from the previous month
Real - The result od divide the value of AmtUSD / DaysOfMonth

I also posted this Line chart with two dimentions do not display correctly

Is the same issue.

Any advice?

Thanks

Re: Line Chart max year and min year behavior

rubenmarin — Wed, 03 Feb 2021 07:51:15 GMT

Hi @Barry-Gon, PFA.

Re: Line Chart max year and min year behavior

Barry-Gon — Wed, 03 Feb 2021 21:54:09 GMT

Thank you very much as always. It works perfect.

Very helpul. 🙂