Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

eleni_theodorid
Contributor

How to manage a report with calculation condition in NPrinting?

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

2 Replies
blaise
Contributor III

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

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).

Highlighted
Lech_Miszkiewicz
Honored Contributor III

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

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.

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
Community Browser