topic Re: Problem with creating chart in QlikView https://community.qlik.com/t5/QlikView/Problem-with-creating-chart/m-p/704309#M1082074 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Thu, 03 Jul 2014 09:52:54 GMT Gysbert_Wassenaar 2014-07-03T09:52:54Z Problem with creating chart https://community.qlik.com/t5/QlikView/Problem-with-creating-chart/m-p/704308#M1082073 <HTML><HEAD></HEAD><BODY><P>Hi i have a table as presented below :</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">Installation</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Date Start</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Date Finish</TH></TR><TR><TD style="padding: 2px;">3500</TD><TD style="padding: 2px;">01.08.2014</TD><TD style="padding: 2px;">31.12.2014</TD></TR><TR><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">02.09.2014</TD><TD style="padding: 2px;">23.11.2014</TD></TR><TR><TD style="padding: 2px;">768</TD><TD style="padding: 2px;">12.07.2014</TD><TD style="padding: 2px;">10.10.2014</TD></TR><TR><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">01.10.2014</TD><TD style="padding: 2px;">01.12.2014</TD></TR><TR><TD style="padding: 2px;">300</TD><TD style="padding: 2px;">01.09.2014</TD><TD style="padding: 2px;">11.11.2014</TD></TR></TBODY></TABLE><P></P><P>I want to create a chart in which i would have as a dimension number of week (on X axis : weeks between min date from Date Start and max date from Date Finish) and on Y axis average amount of installation in particular week. I don't know how to do this because i have just date start/finish and i don't have weeks between this dates <span class="lia-unicode-emoji" title=":confused_face:">😕</span> Is there any way ? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Thu, 03 Jul 2014 09:20:54 GMT https://community.qlik.com/t5/QlikView/Problem-with-creating-chart/m-p/704308#M1082073 2014-07-03T09:20:54Z Re: Problem with creating chart https://community.qlik.com/t5/QlikView/Problem-with-creating-chart/m-p/704309#M1082074 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Thu, 03 Jul 2014 09:52:54 GMT https://community.qlik.com/t5/QlikView/Problem-with-creating-chart/m-p/704309#M1082074 Gysbert_Wassenaar 2014-07-03T09:52:54Z Re: Problem with creating chart https://community.qlik.com/t5/QlikView/Problem-with-creating-chart/m-p/704310#M1082075 <HTML><HEAD></HEAD><BODY><P>wow, brilliant, thank you very much <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 03 Jul 2014 10:17:10 GMT https://community.qlik.com/t5/QlikView/Problem-with-creating-chart/m-p/704310#M1082075 2014-07-03T10:17:10Z Re: Problem with creating chart https://community.qlik.com/t5/QlikView/Problem-with-creating-chart/m-p/704311#M1082076 <HTML><HEAD></HEAD><BODY><P>One more thing, your solution return week no. '1', why ?</P></BODY></HTML> Thu, 03 Jul 2014 12:26:13 GMT https://community.qlik.com/t5/QlikView/Problem-with-creating-chart/m-p/704311#M1082076 2014-07-03T12:26:13Z Re: Re: Problem with creating chart https://community.qlik.com/t5/QlikView/Problem-with-creating-chart/m-p/704312#M1082077 <HTML><HEAD></HEAD><BODY><P>The last three days of december 2014 are part of week 1 of 2015. In the attached qvw I've changed the sort order of the weeks to reflect this.</P></BODY></HTML> Thu, 03 Jul 2014 12:31:22 GMT https://community.qlik.com/t5/QlikView/Problem-with-creating-chart/m-p/704312#M1082077 Gysbert_Wassenaar 2014-07-03T12:31:22Z