topic Re: Bring excel table to QV in QlikView https://community.qlik.com/t5/QlikView/Bring-excel-table-to-QV/m-p/1161798#M521879 <HTML><HEAD></HEAD><BODY><P>No, not as-is. Only data is loaded, not formatting. You'll have to add more data that can be used to determine in Qlikview what formatting needs to be applied. See this blog post for an example: <A href="https://community.qlik.com/qlik-blogpost/2701">How IntervalMatch Solved My Profit and Loss Dilemma</A></P></BODY></HTML> Fri, 27 May 2016 14:20:15 GMT Gysbert_Wassenaar 2016-05-27T14:20:15Z Bring excel table to QV https://community.qlik.com/t5/QlikView/Bring-excel-table-to-QV/m-p/1161797#M521878 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have table in the below format.</P><P></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">Header 1</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Header 2</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Header 3</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Header 4</TH></TR><TR><TD style="padding: 2px;"><STRONG>Standard</STRONG></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">City1</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">City2</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">7</TD><TD style="padding: 2px;">7</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"><STRONG>Advanced</STRONG></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">City4</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">8</TD><TD style="padding: 2px;">9</TD></TR><TR><TD style="padding: 2px;">City5</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">4</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">Normal</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>Is it possible to bring this table as is in Qlikview? and i also want the sub headers like standard, advanced and normal one in bold and line spacing as above.</P><P></P><P>Regards,</P><P>Viresh</P></BODY></HTML> Fri, 27 May 2016 14:16:26 GMT https://community.qlik.com/t5/QlikView/Bring-excel-table-to-QV/m-p/1161797#M521878 vireshkolagimat 2016-05-27T14:16:26Z Re: Bring excel table to QV https://community.qlik.com/t5/QlikView/Bring-excel-table-to-QV/m-p/1161798#M521879 <HTML><HEAD></HEAD><BODY><P>No, not as-is. Only data is loaded, not formatting. You'll have to add more data that can be used to determine in Qlikview what formatting needs to be applied. See this blog post for an example: <A href="https://community.qlik.com/qlik-blogpost/2701">How IntervalMatch Solved My Profit and Loss Dilemma</A></P></BODY></HTML> Fri, 27 May 2016 14:20:15 GMT https://community.qlik.com/t5/QlikView/Bring-excel-table-to-QV/m-p/1161798#M521879 Gysbert_Wassenaar 2016-05-27T14:20:15Z