topic Re: Count Specific - In line chart in QlikView https://community.qlik.com/t5/QlikView/Count-Specific-In-line-chart/m-p/729555#M1068954 <HTML><HEAD></HEAD><BODY><P>Is your Date field a key field that links one or more tables? If so, qlikview cannot know from which table it should count the Date values. You can get undefined behaviour in that case. The solution is to use another field from the table over which you want to count.</P></BODY></HTML> Fri, 22 Aug 2014 12:38:25 GMT Gysbert_Wassenaar 2014-08-22T12:38:25Z Count Specific - In line chart https://community.qlik.com/t5/QlikView/Count-Specific-In-line-chart/m-p/729554#M1068953 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm trying to show average amounts per time in a line chart by summing the amounts per time and divide it by the number of days. However, something is fishy, pls see below. For instance, When choosing 3 (distinct) dates, these two graphs are showing different values. Seems very odd to me. Any ideas?<BR /><IMG alt="Capture.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/64996_Capture.JPG.jpg" style="width: 620px; height: 374px;" /></P></BODY></HTML> Fri, 22 Aug 2014 12:26:40 GMT https://community.qlik.com/t5/QlikView/Count-Specific-In-line-chart/m-p/729554#M1068953 2014-08-22T12:26:40Z Re: Count Specific - In line chart https://community.qlik.com/t5/QlikView/Count-Specific-In-line-chart/m-p/729555#M1068954 <HTML><HEAD></HEAD><BODY><P>Is your Date field a key field that links one or more tables? If so, qlikview cannot know from which table it should count the Date values. You can get undefined behaviour in that case. The solution is to use another field from the table over which you want to count.</P></BODY></HTML> Fri, 22 Aug 2014 12:38:25 GMT https://community.qlik.com/t5/QlikView/Count-Specific-In-line-chart/m-p/729555#M1068954 Gysbert_Wassenaar 2014-08-22T12:38:25Z Re: Re: Count Specific - In line chart https://community.qlik.com/t5/QlikView/Count-Specific-In-line-chart/m-p/729556#M1068955 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert,</P><P></P><P>The below Is all I got.</P><P>And im counting the Date field.</P><P></P><P>Thanks in advance,</P><P>Olle</P><P></P><P></P><P></P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #0000ff;">Text</SPAN>(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">SettlementTime</SPAN><SPAN style="font-size: 8pt;">, 'YYYY-MM-DD')) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">As</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Date </SPAN></P><P></P><P></P><P><IMG alt="Capture.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/65021_Capture.JPG.jpg" /></P></BODY></HTML> Fri, 22 Aug 2014 14:08:16 GMT https://community.qlik.com/t5/QlikView/Count-Specific-In-line-chart/m-p/729556#M1068955 2014-08-22T14:08:16Z Re: Count Specific - In line chart https://community.qlik.com/t5/QlikView/Count-Specific-In-line-chart/m-p/729557#M1068956 <HTML><HEAD></HEAD><BODY><P>Found the problem. Issues with the underlying data.</P><P>//O </P></BODY></HTML> Mon, 25 Aug 2014 08:26:51 GMT https://community.qlik.com/t5/QlikView/Count-Specific-In-line-chart/m-p/729557#M1068956 2014-08-25T08:26:51Z