Multiple Lines chart doesn't look right

[NewToQlikSense]

Hi. I have multiple tables with information about movies (they create a star schema) and I want to create a multiple line chart using Year and DistributorName (the film production studios) as dimensions and Sales as my measure.

Problem is, the chart doesn't look right and I don't know what I'm doing wrong. I attached a photo below.

Any advice is appreciated.

Thanks!

[rubenmarin · Accepted solution]

Hi, note that it darws lines only when there is data for consecutive years.

In the chart layout properties there is an option to set what to do with missing values, select the option to show connections.

Right below is the option to show dots as data values, wich is almost a "must set" if there are lines drawn in years without data.

[NewToQlikSense]

Thanks a lot!!