topic Multiple Attribute Fields for Cross Table in QlikView https://community.qlik.com/t5/QlikView/Multiple-Attribute-Fields-for-Cross-Table/m-p/1325416#M410136 <HTML><HEAD></HEAD><BODY><P>Hi I have multiple attribute fields for a single table how can I use cross table and resolve this in qlik view as I load data. Attached is the data in excel sheet attached.</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"><STRONG>Roll No</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Class 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Class 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Class 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Class 2</STRONG></TH></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Physics</TD><TD style="padding: 2px;">Chemistry</TD><TD style="padding: 2px;">Physics</TD><TD style="padding: 2px;">Chemistry</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">98</TD><TD style="padding: 2px;">45</TD><TD style="padding: 2px;">45</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">77</TD><TD style="padding: 2px;">74</TD><TD style="padding: 2px;">41</TD><TD style="padding: 2px;">17</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">79</TD><TD style="padding: 2px;">78</TD><TD style="padding: 2px;">87</TD><TD style="padding: 2px;">87</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 26 Apr 2017 16:36:22 GMT rammarthi 2017-04-26T16:36:22Z Multiple Attribute Fields for Cross Table https://community.qlik.com/t5/QlikView/Multiple-Attribute-Fields-for-Cross-Table/m-p/1325416#M410136 <HTML><HEAD></HEAD><BODY><P>Hi I have multiple attribute fields for a single table how can I use cross table and resolve this in qlik view as I load data. Attached is the data in excel sheet attached.</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"><STRONG>Roll No</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Class 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Class 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Class 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Class 2</STRONG></TH></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">Physics</TD><TD style="padding: 2px;">Chemistry</TD><TD style="padding: 2px;">Physics</TD><TD style="padding: 2px;">Chemistry</TD></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">98</TD><TD style="padding: 2px;">45</TD><TD style="padding: 2px;">45</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">77</TD><TD style="padding: 2px;">74</TD><TD style="padding: 2px;">41</TD><TD style="padding: 2px;">17</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">79</TD><TD style="padding: 2px;">78</TD><TD style="padding: 2px;">87</TD><TD style="padding: 2px;">87</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 26 Apr 2017 16:36:22 GMT https://community.qlik.com/t5/QlikView/Multiple-Attribute-Fields-for-Cross-Table/m-p/1325416#M410136 rammarthi 2017-04-26T16:36:22Z Re: Multiple Attribute Fields for Cross Table https://community.qlik.com/t5/QlikView/Multiple-Attribute-Fields-for-Cross-Table/m-p/1325417#M410137 <HTML><HEAD></HEAD><BODY><P>May be check this out</P><P><A href="https://community.qlik.com/docs/DOC-4527">multi_header_pivot_import.qvw</A></P></BODY></HTML> Wed, 26 Apr 2017 16:43:05 GMT https://community.qlik.com/t5/QlikView/Multiple-Attribute-Fields-for-Cross-Table/m-p/1325417#M410137 sunny_talwar 2017-04-26T16:43:05Z Re: Multiple Attribute Fields for Cross Table https://community.qlik.com/t5/QlikView/Multiple-Attribute-Fields-for-Cross-Table/m-p/1325418#M410138 <HTML><HEAD></HEAD><BODY><P>could you please share the screenshot of the script?</P></BODY></HTML> Mon, 09 Jul 2018 23:44:26 GMT https://community.qlik.com/t5/QlikView/Multiple-Attribute-Fields-for-Cross-Table/m-p/1325418#M410138 QlikNoviceNo1 2018-07-09T23:44:26Z