topic Re: Problem with import of a excel in QlikView https://community.qlik.com/t5/QlikView/Problem-with-import-of-a-excel/m-p/416861#M1161838 <HTML><HEAD></HEAD><BODY><P>See attached qvw, adapted for the complete set of months.</P></BODY></HTML> Fri, 09 Nov 2012 10:40:31 GMT Gysbert_Wassenaar 2012-11-09T10:40:31Z Problem with import of a excel https://community.qlik.com/t5/QlikView/Problem-with-import-of-a-excel/m-p/416858#M1161835 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Can someone maybe help me out here and show me how I best import attaced excel. </P><P></P><P>I don´t get how I should do with the diffrent headers. </P><P> edit: the +/- don´t have to be imported, I will have qv to do that any way</P><P>/thanks!</P></BODY></HTML> Thu, 08 Nov 2012 16:15:00 GMT https://community.qlik.com/t5/QlikView/Problem-with-import-of-a-excel/m-p/416858#M1161835 2012-11-08T16:15:00Z Re: Problem with import of a excel https://community.qlik.com/t5/QlikView/Problem-with-import-of-a-excel/m-p/416859#M1161836 <HTML><HEAD></HEAD><BODY><P>You will need to crosstab it and then apply some additional transformations. See attached QVW.</P><P></P><P>Regards,</P><P>Vlad</P></BODY></HTML> Thu, 08 Nov 2012 17:19:02 GMT https://community.qlik.com/t5/QlikView/Problem-with-import-of-a-excel/m-p/416859#M1161836 vgutkovsky 2012-11-08T17:19:02Z Re: Problem with import of a excel https://community.qlik.com/t5/QlikView/Problem-with-import-of-a-excel/m-p/416860#M1161837 <HTML><HEAD></HEAD><BODY><P>Thanks. Can´t reaaly get the 2nd and 3d step so i´t did´t work out on my complete sheet. I reattace the file with the complete data. Do you think you can help me again or tell me why it get wrong with the f12 header and higher. </P></BODY></HTML> Fri, 09 Nov 2012 09:57:49 GMT https://community.qlik.com/t5/QlikView/Problem-with-import-of-a-excel/m-p/416860#M1161837 2012-11-09T09:57:49Z Re: Problem with import of a excel https://community.qlik.com/t5/QlikView/Problem-with-import-of-a-excel/m-p/416861#M1161838 <HTML><HEAD></HEAD><BODY><P>See attached qvw, adapted for the complete set of months.</P></BODY></HTML> Fri, 09 Nov 2012 10:40:31 GMT https://community.qlik.com/t5/QlikView/Problem-with-import-of-a-excel/m-p/416861#M1161838 Gysbert_Wassenaar 2012-11-09T10:40:31Z Re: Problem with import of a excel https://community.qlik.com/t5/QlikView/Problem-with-import-of-a-excel/m-p/416862#M1161839 <HTML><HEAD></HEAD><BODY><P>Thanks!</P></BODY></HTML> Fri, 09 Nov 2012 12:42:29 GMT https://community.qlik.com/t5/QlikView/Problem-with-import-of-a-excel/m-p/416862#M1161839 2012-11-09T12:42:29Z