topic Re: Bar Chart For Monthly in QlikView https://community.qlik.com/t5/QlikView/Bar-Chart-For-Monthly/m-p/1393230#M514000 <HTML><HEAD></HEAD><BODY><P>I believe you need to use <A href="https://community.qlik.com/qlik-blogpost/3037">IntervalMatch</A> here and link your master calendar to the two dates in your fact table.</P></BODY></HTML> Fri, 22 Sep 2017 15:19:59 GMT sunny_talwar 2017-09-22T15:19:59Z Bar Chart For Monthly https://community.qlik.com/t5/QlikView/Bar-Chart-For-Monthly/m-p/1393229#M513999 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">I want to created a bar chart based on month.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Data source for example:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Resolved</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Created</STRONG></TH></TR><TR><TD style="padding: 2px;">17/08/2017 00:27</TD><TD style="padding: 2px;">17/08/2017 00:14</TD></TR><TR><TD style="padding: 2px;">16/08/2017 18:26</TD><TD style="padding: 2px;">16/08/2017 18:18</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">16/09/2017 18:18</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">16/08/2017 19:07</SPAN></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">16/09/2017 18:18</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">16/08/2017 17:30</SPAN></TD></TR></TBODY></TABLE><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I want it to be:</P><P style="font-size: 13.3333px;"><IMG alt="bar.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177398_bar.png" /></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">As you see for the August, the count Blue Bar should be 4 and Red Bar should be 2 based on the data source.</P><P style="font-size: 13.3333px;">How do i achieve it based on the month count</P></BODY></HTML> Fri, 22 Sep 2017 03:16:52 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-For-Monthly/m-p/1393229#M513999 2017-09-22T03:16:52Z Re: Bar Chart For Monthly https://community.qlik.com/t5/QlikView/Bar-Chart-For-Monthly/m-p/1393230#M514000 <HTML><HEAD></HEAD><BODY><P>I believe you need to use <A href="https://community.qlik.com/qlik-blogpost/3037">IntervalMatch</A> here and link your master calendar to the two dates in your fact table.</P></BODY></HTML> Fri, 22 Sep 2017 15:19:59 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-For-Monthly/m-p/1393230#M514000 sunny_talwar 2017-09-22T15:19:59Z