topic Re: Gantt Chart in QlikView https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815867#M1023367 <HTML><HEAD></HEAD><BODY><P>can u attach the excel file as well used ?</P></BODY></HTML> Wed, 18 Mar 2015 06:15:44 GMT 2015-03-18T06:15:44Z Gantt Chart https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815854#M1023354 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am trying to create a Gantt chart. I was successful in creating Gantt chart having Planned start date in the expression.</P><P>I also want to display Actual Start dates along with Planned start date. please help me with this.</P><P></P><P><IMG alt="" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/80906_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Tue, 17 Mar 2015 03:56:16 GMT https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815854#M1023354 2015-03-17T03:56:16Z Re: Gantt Chart https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815855#M1023355 <HTML><HEAD></HEAD><BODY><P>Can you add your .qvw file please!!</P></BODY></HTML> Tue, 17 Mar 2015 04:12:51 GMT https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815855#M1023355 2015-03-17T04:12:51Z Re: Gantt Chart https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815856#M1023356 <HTML><HEAD></HEAD><BODY><P>You should be able to just add in the expression for Actual Start Date - make sure it's the secondary expression (initially) - unless there's an error in the Actual Start Date expression, it should show below Planned Date.</P></BODY></HTML> Tue, 17 Mar 2015 06:51:51 GMT https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815856#M1023356 2015-03-17T06:51:51Z Re: Gantt Chart https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815857#M1023357 <HTML><HEAD></HEAD><BODY><P>Hi How do i attach it ?</P></BODY></HTML> Tue, 17 Mar 2015 06:55:51 GMT https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815857#M1023357 2015-03-17T06:55:51Z Re: Gantt Chart https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815858#M1023358 <HTML><HEAD></HEAD><BODY><P>Click Reply -&gt; In the opened space on top of Right-end click 'Use advanced editor' -&gt; on the opened space Right-end bottom you will find the 'Attach' click &amp; upload your .qvw file .</P><P></P><P>Regards</P><P>Lathaa</P></BODY></HTML> Tue, 17 Mar 2015 06:58:33 GMT https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815858#M1023358 2015-03-17T06:58:33Z Re: Gantt Chart https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815859#M1023359 <HTML><HEAD></HEAD><BODY><P>attached <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 17 Mar 2015 07:34:43 GMT https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815859#M1023359 2015-03-17T07:34:43Z Re: Gantt Chart https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815860#M1023360 <HTML><HEAD></HEAD><BODY><P>You need to remove the Account dimension and have a Gantt for each.</P><P></P><P>Just enable the Actual expression and it should work</P></BODY></HTML> Tue, 17 Mar 2015 07:48:35 GMT https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815860#M1023360 2015-03-17T07:48:35Z Re: Gantt Chart https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815861#M1023361 <HTML><HEAD></HEAD><BODY><P>PFA..,</P><P></P><P>Regards</P><P>Lathaa</P></BODY></HTML> Tue, 17 Mar 2015 08:09:41 GMT https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815861#M1023361 2015-03-17T08:09:41Z Re: Gantt Chart https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815862#M1023362 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>See attached qvw.</P></BODY></HTML> Tue, 17 Mar 2015 08:55:17 GMT https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815862#M1023362 2015-03-17T08:55:17Z Re: Gantt Chart https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815863#M1023363 <HTML><HEAD></HEAD><BODY><P>Hi Lathaa,</P><P></P><P>Thank you. But is it possible to get a chart like the one below ??</P><P>the one u attached does not show the number of days for both actual and planned.</P><P><IMG alt="" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/80951_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Tue, 17 Mar 2015 11:02:22 GMT https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815863#M1023363 2015-03-17T11:02:22Z Re: Gantt Chart https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815864#M1023364 <HTML><HEAD></HEAD><BODY><P>Hi Hitha,</P><P></P><P>see the following</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/06/01/recipe-for-gantt-chart">http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/01/recipe-for-gantt-chart</A></P><P></P><P>Regards</P><P></P><P>Andy</P></BODY></HTML> Tue, 17 Mar 2015 11:42:55 GMT https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815864#M1023364 awhitfield 2015-03-17T11:42:55Z Re: Gantt Chart https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815865#M1023365 <HTML><HEAD></HEAD><BODY><P>Hi Hitha,</P><P></P><P>&nbsp; PFA..,Done some sort of Data transformation to satisfy yours.</P><P></P><P>Regards</P><P>Lathaa</P></BODY></HTML> Wed, 18 Mar 2015 02:38:54 GMT https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815865#M1023365 2015-03-18T02:38:54Z Re: Gantt Chart https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815866#M1023366 <HTML><HEAD></HEAD><BODY><P>thanks a lot <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> got it</P></BODY></HTML> Wed, 18 Mar 2015 06:09:03 GMT https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815866#M1023366 2015-03-18T06:09:03Z Re: Gantt Chart https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815867#M1023367 <HTML><HEAD></HEAD><BODY><P>can u attach the excel file as well used ?</P></BODY></HTML> Wed, 18 Mar 2015 06:15:44 GMT https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815867#M1023367 2015-03-18T06:15:44Z Re: Gantt Chart https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815868#M1023368 <HTML><HEAD></HEAD><BODY><P>PFA..,</P><P>You can also create a straight table and export to excel as well - To understand the data.</P><P></P><P>Regards</P><P>Lathaa</P></BODY></HTML> Wed, 18 Mar 2015 06:29:41 GMT https://community.qlik.com/t5/QlikView/Gantt-Chart/m-p/815868#M1023368 2015-03-18T06:29:41Z