How to manage a report with calculation condition in NPrinting?

[eleni_theodorid]

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

[blaise]

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

[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

• If it is version 16.X you can levarage variable filters to select required dates
• If it is version 17.X you cannot use variables filters, but there is a workaround:
  • here is a workaround description (read whole topic but my comment is at the bottom of it) : Variable filters in NPrinting V17‌ also another technique here:NPrinting creating filter from selection string?

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.