topic Re: Excel report in Nprinting in Qlik NPrinting https://community.qlik.com/t5/Qlik-NPrinting/Excel-report-in-Nprinting/m-p/1182310#M12220 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I think indirect would help you with that.</P><P></P><P>=Indirect("A3")</P></BODY></HTML> Tue, 13 Sep 2016 17:56:46 GMT Anonymous 2016-09-13T17:56:46Z Excel report in Nprinting https://community.qlik.com/t5/Qlik-NPrinting/Excel-report-in-Nprinting/m-p/1182309#M12219 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to create a report in excel with a few if formula's refering to another sheet. </P><P></P><P>So this is the issue:</P><P></P><P>Sheet 1: <SPAN style="font-size: 10pt; line-height: 1.5em;">I have a few formulas refering to sheet 2</SPAN></P><P></P><P>Sheet 2: is a table i'm importing from qlikview. It has a 4 columns and some rows. </P><P></P><P>I want sheet 1 to show some data only if there is "something" in a cell on sheet 2. </P><P></P><P>However the problem im facing is that whenever im running the report the table is being "insterted" what makes the formula in sheet 1 jump all the rows thats being insterted. So my formula was refering to cell A3 but because the table was "inserted" now its refering to cell A685. I tried dollar signs but it still went from $A$3 to $A$685. </P><P></P><P>Any idea's how i can fix this? </P><P></P><P>Thanks in advance. </P></BODY></HTML> Tue, 13 Sep 2016 08:36:38 GMT https://community.qlik.com/t5/Qlik-NPrinting/Excel-report-in-Nprinting/m-p/1182309#M12219 2016-09-13T08:36:38Z Re: Excel report in Nprinting https://community.qlik.com/t5/Qlik-NPrinting/Excel-report-in-Nprinting/m-p/1182310#M12220 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I think indirect would help you with that.</P><P></P><P>=Indirect("A3")</P></BODY></HTML> Tue, 13 Sep 2016 17:56:46 GMT https://community.qlik.com/t5/Qlik-NPrinting/Excel-report-in-Nprinting/m-p/1182310#M12220 Anonymous 2016-09-13T17:56:46Z Re: Excel report in Nprinting https://community.qlik.com/t5/Qlik-NPrinting/Excel-report-in-Nprinting/m-p/1182311#M12221 <HTML><HEAD></HEAD><BODY><P>Hi Fernando, </P><P></P><P>Sorry this doesnt seem to be the solution either. </P></BODY></HTML> Wed, 14 Sep 2016 07:18:31 GMT https://community.qlik.com/t5/Qlik-NPrinting/Excel-report-in-Nprinting/m-p/1182311#M12221 2016-09-14T07:18:31Z