topic Re:Cross Table in QlikView

topic Re:Cross Table in QlikView https://community.qlik.com/t5/QlikView/Re-Cross-Table/m-p/139766#M758054 <HTML><HEAD></HEAD><BODY><P>Worked for me with your xls file. Try to create a new QVW.</P><P></P><P></P><P>Test:</P><P>Crosstable(Month,Sales)</P><P>LOAD Department, </P><P>     Jan, </P><P>     Feb, </P><P>     Mar, </P><P>     Apr, </P><P>     May, </P><P>     Jun, </P><P>     Jul, </P><P>     Aug, </P><P>     Sep, </P><P>     Oct, </P><P>     Nov, </P><P>     Dec</P><P>FROM</P><P>[Crosstable example.xls]</P><P>(biff, embedded labels, table is Sheet1$);</P><P></P><P><IMG alt="2018-09-01 16_26_39-QlikView x64 - [E__Users_Stefan_Downloads_TEST_280818.qvw_].png" class="jive-image image-1" src="/legacyfs/online/212412_2018-09-01 16_26_39-QlikView x64 - [E__Users_Stefan_Downloads_TEST_280818.qvw_].png" style="height: auto;" /></P></BODY></HTML> Sat, 01 Sep 2018 14:27:42 GMT swuehl 2018-09-01T14:27:42Z Re:Cross Table https://community.qlik.com/t5/QlikView/Re-Cross-Table/m-p/139765#M758053 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>Cross table xls file error</P><P></P><P><IMG alt="Capture1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/212405_Capture1.PNG" style="height: auto; width: auto;" /></P><P></P><P><IMG alt="Capture2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/212406_Capture2.PNG" style="height: 447px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Re-Cross-Table/m-p/139765#M758053 t_vijay_qlik 2020-11-25T16:16:04Z Re:Cross Table https://community.qlik.com/t5/QlikView/Re-Cross-Table/m-p/139766#M758054 <HTML><HEAD></HEAD><BODY><P>Worked for me with your xls file. Try to create a new QVW.</P><P></P><P></P><P>Test:</P><P>Crosstable(Month,Sales)</P><P>LOAD Department, </P><P>     Jan, </P><P>     Feb, </P><P>     Mar, </P><P>     Apr, </P><P>     May, </P><P>     Jun, </P><P>     Jul, </P><P>     Aug, </P><P>     Sep, </P><P>     Oct, </P><P>     Nov, </P><P>     Dec</P><P>FROM</P><P>[Crosstable example.xls]</P><P>(biff, embedded labels, table is Sheet1$);</P><P></P><P><IMG alt="2018-09-01 16_26_39-QlikView x64 - [E__Users_Stefan_Downloads_TEST_280818.qvw_].png" class="jive-image image-1" src="/legacyfs/online/212412_2018-09-01 16_26_39-QlikView x64 - [E__Users_Stefan_Downloads_TEST_280818.qvw_].png" style="height: auto;" /></P></BODY></HTML> Sat, 01 Sep 2018 14:27:42 GMT https://community.qlik.com/t5/QlikView/Re-Cross-Table/m-p/139766#M758054 swuehl 2018-09-01T14:27:42Z