2 Replies Latest reply: May 9, 2018 12:33 AM by Lech Miszkiewicz RSS

    How to manage a report with calculation condition in NPrinting?

    Eleni Theodoridou

      Hi all,

       

      I have a pivot table in QV which is using calculation condition, it calculates the expression only when the user gives a date for CY and a date for PY in two variables, these variables are used in my set analysis expressions. On document open these variables are empty. When I am trying to use this pivot table in NPrinting report it's empty due to the empty variables, how can I give dynamically values to the variables in NPrinting so it could generate the report properly?

       

      Regards,
      Eleni

        • Re: How to manage a report with calculation condition in NPrinting?
          Johan Hessler

          My recommendation would be to create a new object in the qvw without calculation conditions (it could also be feasible to create a new qvw just for NP purpose with only the data/objects you need).

          • Re: How to manage a report with calculation condition in NPrinting?
            Lech Miszkiewicz

            Hi Eleni,

            I agree with Johan. It is best practice to create a dedicated document for NPrinitng reporting. more info here:

            https://community.qlik.com/thread/260840?q=qvw%20size

             

            You did not give us details which NPrinting version you are using

             

            Just to summerize - regardles if you keep the same or create new application for NPrinting still you will have to change the variable definition (chaneg it to expression driven by field selection--> NPrinting filter based on field) change pivot table expressions to operate on fields (not variables)


            cheers

            Lech

            ---------------------------------------------

            When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.