topic Graphic : Issue with constant line in QlikView https://community.qlik.com/t5/QlikView/Graphic-Issue-with-constant-line/m-p/207347#M63137 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I would like to draw a line (call it "first line") on a chart of this type y = constant * x in a continuous axis of dates with a another line (call it "second line") from my data. So I made two expressions. But the issue is that I don't have data for every month of this axis in my second line, so my first line is not a straight line. How to force QV to calculate values for my first line for every value of my axis in order to have a straight line ?</P><P>PS : my first line is defined has this expression : [constant] which value is 2, and I selected "total sum" (not sure of the term, using french version, but it's the option in the left down corner of expression tabs).</P></BODY></HTML> Mon, 11 Jan 2010 15:45:34 GMT 2010-01-11T15:45:34Z Graphic : Issue with constant line https://community.qlik.com/t5/QlikView/Graphic-Issue-with-constant-line/m-p/207347#M63137 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I would like to draw a line (call it "first line") on a chart of this type y = constant * x in a continuous axis of dates with a another line (call it "second line") from my data. So I made two expressions. But the issue is that I don't have data for every month of this axis in my second line, so my first line is not a straight line. How to force QV to calculate values for my first line for every value of my axis in order to have a straight line ?</P><P>PS : my first line is defined has this expression : [constant] which value is 2, and I selected "total sum" (not sure of the term, using french version, but it's the option in the left down corner of expression tabs).</P></BODY></HTML> Mon, 11 Jan 2010 15:45:34 GMT https://community.qlik.com/t5/QlikView/Graphic-Issue-with-constant-line/m-p/207347#M63137 2010-01-11T15:45:34Z Graphic : Issue with constant line https://community.qlik.com/t5/QlikView/Graphic-Issue-with-constant-line/m-p/207348#M63138 <HTML><HEAD></HEAD><BODY><P>I solved my problem with :</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">[rythme_inclusion] * fabs(round((makedate(year(min({Inclusion} all [date_reelle])),month(min({Inclusion} all [date_reelle]))) - makedate(year([date_reelle]),month([date_reelle])))/30.4375))</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Mon, 11 Jan 2010 17:38:33 GMT https://community.qlik.com/t5/QlikView/Graphic-Issue-with-constant-line/m-p/207348#M63138 2010-01-11T17:38:33Z