topic Count in QlikView https://community.qlik.com/t5/QlikView/Count/m-p/1404804#M512755 <HTML><HEAD></HEAD><BODY><P>Data Source For Example:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Created Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Resolved Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>NoOfMinutes</STRONG></TH></TR><TR><TD style="padding: 2px;">15/08/2017 17:37</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">15/08/2017 18:09</SPAN></TD><TD style="padding: 2px;">32</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">11/08/2017 15:04</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">11/08/2017 15:41</SPAN></TD><TD style="padding: 2px;">37</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">08/08/2017 11:47</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">11/08/2017 21:20</SPAN></TD><TD style="padding: 2px;">573</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">11/08/2017 12:30</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">06/09/2017 15:15</SPAN></TD><TD style="padding: 2px;">37704</TD></TR></TBODY></TABLE><P></P><P>How do i count the created date in bar chart?</P><P></P><P>Conditional</P><P>&lt;= 45 Minutes</P><P>&gt; 45 Minutes</P><P></P><P>Count Based on Created Date and Resolved Month.</P><P>I am using alternate state so that when i click on a month it will display accordingly</P><P></P><P><STRONG>The result will be like this:</STRONG></P><P><IMG alt="i.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/178797_i.png" style="height: auto; width: auto;" /></P><P>Created (August)</P><P>&lt;= 45 Minutes = 2</P><P>&gt; 45 Minutes = 2</P><P></P><P>Resolved (August)</P><P>&lt;= 45 Minutes = 2</P><P>&gt; 45 Minutes = 1</P></BODY></HTML> Fri, 06 Oct 2017 02:13:09 GMT 2017-10-06T02:13:09Z Count https://community.qlik.com/t5/QlikView/Count/m-p/1404804#M512755 <HTML><HEAD></HEAD><BODY><P>Data Source For Example:</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Created Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Resolved Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>NoOfMinutes</STRONG></TH></TR><TR><TD style="padding: 2px;">15/08/2017 17:37</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">15/08/2017 18:09</SPAN></TD><TD style="padding: 2px;">32</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">11/08/2017 15:04</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">11/08/2017 15:41</SPAN></TD><TD style="padding: 2px;">37</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">08/08/2017 11:47</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">11/08/2017 21:20</SPAN></TD><TD style="padding: 2px;">573</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">11/08/2017 12:30</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">06/09/2017 15:15</SPAN></TD><TD style="padding: 2px;">37704</TD></TR></TBODY></TABLE><P></P><P>How do i count the created date in bar chart?</P><P></P><P>Conditional</P><P>&lt;= 45 Minutes</P><P>&gt; 45 Minutes</P><P></P><P>Count Based on Created Date and Resolved Month.</P><P>I am using alternate state so that when i click on a month it will display accordingly</P><P></P><P><STRONG>The result will be like this:</STRONG></P><P><IMG alt="i.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/178797_i.png" style="height: auto; width: auto;" /></P><P>Created (August)</P><P>&lt;= 45 Minutes = 2</P><P>&gt; 45 Minutes = 2</P><P></P><P>Resolved (August)</P><P>&lt;= 45 Minutes = 2</P><P>&gt; 45 Minutes = 1</P></BODY></HTML> Fri, 06 Oct 2017 02:13:09 GMT https://community.qlik.com/t5/QlikView/Count/m-p/1404804#M512755 2017-10-06T02:13:09Z Re: Count https://community.qlik.com/t5/QlikView/Count/m-p/1404805#M512756 <HTML><HEAD></HEAD><BODY><P>see attached file</P><P></P><P>hope this helps</P></BODY></HTML> Fri, 06 Oct 2017 17:52:24 GMT https://community.qlik.com/t5/QlikView/Count/m-p/1404805#M512756 Frank_Hartmann 2017-10-06T17:52:24Z