https://community.qlik.com/t5/Qlik-Automate/Line-Chart-with-Null-Values/m-p/2442397#M3706 <P><SPAN>I have a line chart. Is it possible to also display null values even if I don't have them in the data model?</SPAN></P> Thu, 18 Apr 2024 06:37:57 GMT Alihan_02 2024-04-18T06:37:57Z https://community.qlik.com/t5/Qlik-Automate/Line-Chart-with-Null-Values/m-p/2442397#M3706 <P><SPAN>I have a line chart. Is it possible to also display null values even if I don't have them in the data model?</SPAN></P> Thu, 18 Apr 2024 06:37:57 GMT https://community.qlik.com/t5/Qlik-Automate/Line-Chart-with-Null-Values/m-p/2442397#M3706 Alihan_02 2024-04-18T06:37:57Z https://community.qlik.com/t5/Qlik-Automate/Line-Chart-with-Null-Values/m-p/2442441#M3707 <P>Hi, <BR /><BR />You have 3 options to handle null value in a line chart:<BR />- Gaps<BR />- Connections<BR />- Zeros<BR /><BR />In your case I think you want to use the Zeros option. The option is in Presentation &gt; Missing value<BR /><BR />Kind regards</P> Thu, 18 Apr 2024 07:40:17 GMT https://community.qlik.com/t5/Qlik-Automate/Line-Chart-with-Null-Values/m-p/2442441#M3707 mpc 2024-04-18T07:40:17Z https://community.qlik.com/t5/Qlik-Automate/Line-Chart-with-Null-Values/m-p/2442450#M3708 <P><SPAN>I don't know what you mean by that, but I found a solution. This is the formula: + sum({1}0)</SPAN></P> Thu, 18 Apr 2024 07:49:59 GMT https://community.qlik.com/t5/Qlik-Automate/Line-Chart-with-Null-Values/m-p/2442450#M3708 Alihan_02 2024-04-18T07:49:59Z