Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Graphic : Issue with constant line

Hi,

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 ?

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).

1 Solution

Accepted Solutions
Not applicable
Author

I solved my problem with :

[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))


View solution in original post

1 Reply
Not applicable
Author

I solved my problem with :

[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))