topic Re: Excel file format. in QlikView https://community.qlik.com/t5/QlikView/Excel-file-format/m-p/1178919#M896075 <HTML><HEAD></HEAD><BODY><P>May be like this?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/133078_Capture.PNG" style="height: 69px; width: 620px;" /></P></BODY></HTML> Fri, 29 Jul 2016 19:31:50 GMT vishsaggi 2016-07-29T19:31:50Z Excel file format. https://community.qlik.com/t5/QlikView/Excel-file-format/m-p/1178917#M896073 <HTML><HEAD></HEAD><BODY><P>Hi I have attached an&nbsp; excel file,In sheet 1 I have the original format and I want to convert that to the format as in sheet 2 in qlikview.</P><P>Can this be done ?</P><P></P><P>Thanks much.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Excel-file-format/m-p/1178917#M896073 2020-11-25T16:16:04Z Re: Excel file format. https://community.qlik.com/t5/QlikView/Excel-file-format/m-p/1178918#M896074 <HTML><HEAD></HEAD><BODY><P>You can fix the data in the backend and see the way you want using a pivot table:</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/133077_Capture.PNG" style="height: 87px; width: 620px;" /></P></BODY></HTML> Fri, 29 Jul 2016 19:29:12 GMT https://community.qlik.com/t5/QlikView/Excel-file-format/m-p/1178918#M896074 sunny_talwar 2016-07-29T19:29:12Z Re: Excel file format. https://community.qlik.com/t5/QlikView/Excel-file-format/m-p/1178919#M896075 <HTML><HEAD></HEAD><BODY><P>May be like this?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/133078_Capture.PNG" style="height: 69px; width: 620px;" /></P></BODY></HTML> Fri, 29 Jul 2016 19:31:50 GMT https://community.qlik.com/t5/QlikView/Excel-file-format/m-p/1178919#M896075 vishsaggi 2016-07-29T19:31:50Z