Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
paolojolly
Contributor

accumulated line chart starting from zero

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,

Tags (1)
Labels (2)
2 Replies
jwjackso
Valued Contributor

Re: accumulated line chart starting from zero

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.

scale.PNG

paolojolly
Contributor

Re: accumulated line chart starting from zero

Thanks, maybe I explained myself wrongly

I need to arrive at a result like the following 

finale result.png

 

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

It's possible to do it?
Thanks again