topic IMPORTING FROM EXCEL, COPYING FROM ROWS ABOVE in QlikView https://community.qlik.com/t5/QlikView/IMPORTING-FROM-EXCEL-COPYING-FROM-ROWS-ABOVE/m-p/878816#M306792 <HTML><HEAD></HEAD><BODY><P>When importing an EXCEL spreadsheet I'd like to replace all TOTAL rows with the HEADER from above.</P><P>Looking at the attached spreadsheet, I would want the TOTAL description in the group to be replaced by CANADA and USA.</P><P></P><P>Is there an easy way to accomplish this?</P><P><BR />Thanks!</P></BODY></HTML> Tue, 21 Apr 2015 22:30:55 GMT 2015-04-21T22:30:55Z IMPORTING FROM EXCEL, COPYING FROM ROWS ABOVE https://community.qlik.com/t5/QlikView/IMPORTING-FROM-EXCEL-COPYING-FROM-ROWS-ABOVE/m-p/878816#M306792 <HTML><HEAD></HEAD><BODY><P>When importing an EXCEL spreadsheet I'd like to replace all TOTAL rows with the HEADER from above.</P><P>Looking at the attached spreadsheet, I would want the TOTAL description in the group to be replaced by CANADA and USA.</P><P></P><P>Is there an easy way to accomplish this?</P><P><BR />Thanks!</P></BODY></HTML> Tue, 21 Apr 2015 22:30:55 GMT https://community.qlik.com/t5/QlikView/IMPORTING-FROM-EXCEL-COPYING-FROM-ROWS-ABOVE/m-p/878816#M306792 2015-04-21T22:30:55Z Re: IMPORTING FROM EXCEL, COPYING FROM ROWS ABOVE https://community.qlik.com/t5/QlikView/IMPORTING-FROM-EXCEL-COPYING-FROM-ROWS-ABOVE/m-p/878817#M306793 <HTML><HEAD></HEAD><BODY><P>Try the transformation in the attached app.</P></BODY></HTML> Tue, 21 Apr 2015 23:24:36 GMT https://community.qlik.com/t5/QlikView/IMPORTING-FROM-EXCEL-COPYING-FROM-ROWS-ABOVE/m-p/878817#M306793 srchilukoori 2015-04-21T23:24:36Z Re: IMPORTING FROM EXCEL, COPYING FROM ROWS ABOVE https://community.qlik.com/t5/QlikView/IMPORTING-FROM-EXCEL-COPYING-FROM-ROWS-ABOVE/m-p/878818#M306794 <HTML><HEAD></HEAD><BODY><P>Perfect!&nbsp; Thanks </P></BODY></HTML> Wed, 22 Apr 2015 00:22:04 GMT https://community.qlik.com/t5/QlikView/IMPORTING-FROM-EXCEL-COPYING-FROM-ROWS-ABOVE/m-p/878818#M306794 2015-04-22T00:22:04Z