Solved: NPrinting formulas in Power Point not calculated - Qlik Community

pwagner · ‎2021-11-12

Hello all!

In our Power Point NPrinting report we us a formula to calculate the curent reporting date.

On 28 of 30 slides is will be calculated correctly:

On 2 of the 30 slides we do not get the date, instead we see <BusinessDate>

Do you have an idea how we can solve this issue?

Thank you.

Best regards, Patrick

pwagner · ‎2021-11-13

We found the solution.

In the previous text was a "<" (... < 28 ... as af <BusinessDate>) and therefore the formula did not work.

We changed it to 1-28 and now the formula works.

Best regards, Patrick

View solution in original post

Ruggero_Piccoli · ‎2021-11-12

Hi,

Can you share the screenshots of the entire template?
Can you share the formula?
Are you using Pages to create different slides?
If yes, can you try to calculate the formula for the values of the field used in Pages that are not generating correct values of the formula? For example you can insert the formula in the source Qlik Sense app, apply the same filter of the report and check the result.

Best Regards,

Ruggero

Best Regards,
Ruggero
---------------------------------------------
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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

pwagner · ‎2021-11-13

We found the solution.

In the previous text was a "<" (... < 28 ... as af <BusinessDate>) and therefore the formula did not work.

We changed it to 1-28 and now the formula works.

Best regards, Patrick

NPrinting formulas in Power Point not calculated

Qlik NPrinting February 2021

Qlik Sense