topic Formatted Gantt chart import in QlikView https://community.qlik.com/t5/QlikView/Formatted-Gantt-chart-import/m-p/640675#M679011 <HTML><HEAD></HEAD><BODY><DIV style="color: #000000; font-family: Tahoma; text-align: -webkit-auto; font-size: medium;">The ad agency provides a number of manually generated Gantt charts on a weekly basis<P></P><P style="color: #000000; font-family: Tahoma; text-align: -webkit-auto; font-size: medium;"></P><P style="color: #000000; font-family: Tahoma; text-align: -webkit-auto; font-size: medium;">Anybody have an idea how to turn this type of data into something consumable by Qlik?</P><P style="color: #000000; font-family: Tahoma; text-align: -webkit-auto; font-size: medium;"></P><P style="color: #000000; font-family: Tahoma; text-align: -webkit-auto; font-size: medium;">I presume there is some way for VBA to evaluate the colors of a cell to convert that into data- even if applied manually? </P><P style="color: #000000; font-family: Tahoma; text-align: -webkit-auto; font-size: medium;"></P><P style="color: #000000; font-family: Tahoma; text-align: -webkit-auto; font-size: medium;"></P><P style="color: #000000; font-family: Tahoma; text-align: -webkit-auto; font-size: medium;">I've attached a sample xlsx (2 tabs-"PreConverted" and "Converted")&nbsp; and QVW file. It would be really nice if the data went from the "PreConverted" to "Converted" format&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P style="color: #000000; font-family: Tahoma; text-align: -webkit-auto; font-size: medium;"><IMG alt="ganttPic.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/59249_ganttPic.jpg" style="width: 620px; height: 269px;" /></P></DIV></BODY></HTML> Tue, 20 May 2014 21:47:05 GMT Daniel_Moore 2014-05-20T21:47:05Z Formatted Gantt chart import https://community.qlik.com/t5/QlikView/Formatted-Gantt-chart-import/m-p/640675#M679011 <HTML><HEAD></HEAD><BODY><DIV style="color: #000000; font-family: Tahoma; text-align: -webkit-auto; font-size: medium;">The ad agency provides a number of manually generated Gantt charts on a weekly basis<P></P><P style="color: #000000; font-family: Tahoma; text-align: -webkit-auto; font-size: medium;"></P><P style="color: #000000; font-family: Tahoma; text-align: -webkit-auto; font-size: medium;">Anybody have an idea how to turn this type of data into something consumable by Qlik?</P><P style="color: #000000; font-family: Tahoma; text-align: -webkit-auto; font-size: medium;"></P><P style="color: #000000; font-family: Tahoma; text-align: -webkit-auto; font-size: medium;">I presume there is some way for VBA to evaluate the colors of a cell to convert that into data- even if applied manually? </P><P style="color: #000000; font-family: Tahoma; text-align: -webkit-auto; font-size: medium;"></P><P style="color: #000000; font-family: Tahoma; text-align: -webkit-auto; font-size: medium;"></P><P style="color: #000000; font-family: Tahoma; text-align: -webkit-auto; font-size: medium;">I've attached a sample xlsx (2 tabs-"PreConverted" and "Converted")&nbsp; and QVW file. It would be really nice if the data went from the "PreConverted" to "Converted" format&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P style="color: #000000; font-family: Tahoma; text-align: -webkit-auto; font-size: medium;"><IMG alt="ganttPic.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/59249_ganttPic.jpg" style="width: 620px; height: 269px;" /></P></DIV></BODY></HTML> Tue, 20 May 2014 21:47:05 GMT https://community.qlik.com/t5/QlikView/Formatted-Gantt-chart-import/m-p/640675#M679011 Daniel_Moore 2014-05-20T21:47:05Z