topic Re: accumulated line chart starting from zero in QlikView

accumulated line chart starting from zero

paolojolly — Sat, 16 Nov 2024 21:06:23 GMT

Hi everyone,

in a line chart I have to compare weekly comulative sales of two customers over the years
If i use only one dimension

=IF(DATA_RIF_DOC > makedate(year(AddYears(vDataFin, -2)), 1, 1),
WeekDualTC
)

lines starts from zero values

If I add another dimension
=IF(DATA_RIF_DOC > makedate(year(AddYears(vDataFin, -2)), 1, 1),
CD_CLIENTE &'-'& YEAR(DATA_RIF_DOC)
)

lines no longer start from zero

I have to add the second dimension because I have to see the data of the two customers over the years

Can someone help me?

Thanks,

Re: accumulated line chart starting from zero

jwjackso — Fri, 05 Apr 2019 18:49:22 GMT

It is still starts at zero, the problem is scale. The first dimension goes from 0 to 21, the second dimension starts around 500. If you very carefully put the cursor over the line near zero, you will see the first dimension. see image.

Re: accumulated line chart starting from zero

paolojolly — Mon, 08 Apr 2019 07:06:14 GMT

Thanks, maybe I explained myself wrongly

I need to arrive at a result like the following

in which chart lines start from x and y zero value (see the red lines)

It's possible to do it?
Thanks again