topic Re: Count dates in straight chart in QlikView https://community.qlik.com/t5/QlikView/Count-dates-in-straight-chart/m-p/394156#M146980 <HTML><HEAD></HEAD><BODY><P>Have you tried <EM>Date </EM>as dimension and</P><P></P><P><EM>=count(Date) </EM></P><P></P><P>as expression?</P></BODY></HTML> Fri, 30 Nov 2012 12:29:56 GMT swuehl 2012-11-30T12:29:56Z Count dates in straight chart https://community.qlik.com/t5/QlikView/Count-dates-in-straight-chart/m-p/394155#M146979 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P> I'm trying to count the instances of a particular field (in this case a date) in a straight chart. What we're looking for is:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="172" style="width: 193px; border: 1px solid rgb(0, 0, 0); height: 174px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Date</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Count</STRONG></SPAN></TH></TR><TR><TD>27/02/2012</TD><TD> 3</TD></TR><TR><TD>28/02/2012</TD><TD> 2</TD></TR><TR><TD>01/03/2012</TD><TD> 8</TD></TR><TR><TD>04/03/2012</TD><TD> 3</TD></TR></TBODY></TABLE><P></P><P>Can anyone help? As may be obvious, I am not an experienced QV designer...</P><P></P><P>Thanks, Gavin</P></BODY></HTML> Fri, 30 Nov 2012 12:24:18 GMT https://community.qlik.com/t5/QlikView/Count-dates-in-straight-chart/m-p/394155#M146979 2012-11-30T12:24:18Z Re: Count dates in straight chart https://community.qlik.com/t5/QlikView/Count-dates-in-straight-chart/m-p/394156#M146980 <HTML><HEAD></HEAD><BODY><P>Have you tried <EM>Date </EM>as dimension and</P><P></P><P><EM>=count(Date) </EM></P><P></P><P>as expression?</P></BODY></HTML> Fri, 30 Nov 2012 12:29:56 GMT https://community.qlik.com/t5/QlikView/Count-dates-in-straight-chart/m-p/394156#M146980 swuehl 2012-11-30T12:29:56Z Re: Count dates in straight chart https://community.qlik.com/t5/QlikView/Count-dates-in-straight-chart/m-p/394157#M146981 <HTML><HEAD></HEAD><BODY><P>Perfect, thanks swuehl.</P></BODY></HTML> Fri, 30 Nov 2012 12:43:24 GMT https://community.qlik.com/t5/QlikView/Count-dates-in-straight-chart/m-p/394157#M146981 2012-11-30T12:43:24Z