topic Re: Graph in QlikView https://community.qlik.com/t5/QlikView/Graph/m-p/26363#M780751 <HTML><HEAD></HEAD><BODY><P>In dimension tab of your chart please check option suppress when value is null</P></BODY></HTML> Wed, 28 Mar 2018 14:12:10 GMT vijetas42 2018-03-28T14:12:10Z Graph https://community.qlik.com/t5/QlikView/Graph/m-p/26361#M780749 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="197770" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/197770_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>My graph has 12 months data and no blanks.</P><P></P><P>The dimension I have used is month and this is one of the key common variables (as I have loaded in 17 excel files).</P><P></P><P>All files are from March to Feb with no blanks so I don't understand why I am getting the extra data point after feb?</P><P></P><P>Can anyone help me with this please?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Graph/m-p/26361#M780749 Anonymous 2020-11-25T16:16:04Z Re: Graph https://community.qlik.com/t5/QlikView/Graph/m-p/26362#M780750 <HTML><HEAD></HEAD><BODY><P>can you convert that into stright table /pivot table&nbsp; and see which row/column showing null </P></BODY></HTML> Wed, 28 Mar 2018 14:11:17 GMT https://community.qlik.com/t5/QlikView/Graph/m-p/26362#M780750 Chanty4u 2018-03-28T14:11:17Z Re: Graph https://community.qlik.com/t5/QlikView/Graph/m-p/26363#M780751 <HTML><HEAD></HEAD><BODY><P>In dimension tab of your chart please check option suppress when value is null</P></BODY></HTML> Wed, 28 Mar 2018 14:12:10 GMT https://community.qlik.com/t5/QlikView/Graph/m-p/26363#M780751 vijetas42 2018-03-28T14:12:10Z Re: Graph https://community.qlik.com/t5/QlikView/Graph/m-p/26364#M780752 <HTML><HEAD></HEAD><BODY><P>Just figured it out and did this.</P><P>Thank you</P></BODY></HTML> Wed, 28 Mar 2018 14:13:00 GMT https://community.qlik.com/t5/QlikView/Graph/m-p/26364#M780752 Anonymous 2018-03-28T14:13:00Z Re: Graph https://community.qlik.com/t5/QlikView/Graph/m-p/26365#M780753 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: 'trebuchet ms', geneva; color: #000000;">Hi Sarah,</SPAN></P><P><SPAN style="color: #000000; font-family: 'trebuchet ms', geneva;">The expected reason is, when you join with multiple data sources, we will get this kind of data discrepancy. To resolve that,</SPAN></P><P><SPAN style="color: #000000; font-family: 'trebuchet ms', geneva;">In dimensions, Kindly checkmark the '<STRONG style="font-size: 12pt;">Suppress When Value is null</STRONG>" as shown in below snapshot.<IMG alt="Capture1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/197780_Capture1.PNG" style="height: 559px; width: 620px;" /></SPAN></P><P></P></BODY></HTML> Wed, 28 Mar 2018 14:13:32 GMT https://community.qlik.com/t5/QlikView/Graph/m-p/26365#M780753 Anonymous 2018-03-28T14:13:32Z