topic Report printing extra field information in QlikView https://community.qlik.com/t5/QlikView/Report-printing-extra-field-information/m-p/567707#M544411 <HTML><HEAD></HEAD><BODY><P>Greetings,</P><P></P><P>I have a table that has a conditional display on it. (=if(Exclude=0,ReconcilingDepartment)</P><P></P><P>This works great on the table but not in the report with the table in it. Instead of skipping over the Reconciling Departments that have an Exclude =1, the report prints ALL reconciling departments. Is there any way to have a report with a table where the table in the report displays exactly like the table on the sheet?</P></BODY></HTML> Fri, 11 Apr 2014 18:32:46 GMT 2014-04-11T18:32:46Z Report printing extra field information https://community.qlik.com/t5/QlikView/Report-printing-extra-field-information/m-p/567707#M544411 <HTML><HEAD></HEAD><BODY><P>Greetings,</P><P></P><P>I have a table that has a conditional display on it. (=if(Exclude=0,ReconcilingDepartment)</P><P></P><P>This works great on the table but not in the report with the table in it. Instead of skipping over the Reconciling Departments that have an Exclude =1, the report prints ALL reconciling departments. Is there any way to have a report with a table where the table in the report displays exactly like the table on the sheet?</P></BODY></HTML> Fri, 11 Apr 2014 18:32:46 GMT https://community.qlik.com/t5/QlikView/Report-printing-extra-field-information/m-p/567707#M544411 2014-04-11T18:32:46Z Re: Report printing extra field information https://community.qlik.com/t5/QlikView/Report-printing-extra-field-information/m-p/567708#M544412 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>Create another table with fields&nbsp; ReconcilingDepartment (as key and link to the data model) and ReconcilingDepartmentPrintable.</P><P>Keep only those department records that you want (Exclude=0).</P><P>Then us new field in report instead of&nbsp; ReconcilingDepartment.</P></BODY></HTML> Sat, 12 Apr 2014 10:02:53 GMT https://community.qlik.com/t5/QlikView/Report-printing-extra-field-information/m-p/567708#M544412 whiteline 2014-04-12T10:02:53Z Re: Report printing extra field information https://community.qlik.com/t5/QlikView/Report-printing-extra-field-information/m-p/567709#M544413 <HTML><HEAD></HEAD><BODY><P>That is an excellent trick. Thank you!</P></BODY></HTML> Tue, 15 Apr 2014 17:32:57 GMT https://community.qlik.com/t5/QlikView/Report-printing-extra-field-information/m-p/567709#M544413 2014-04-15T17:32:57Z