Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
pacoli2013
Creator
Creator

Qlikview reports in different Languages with N-printing

Hello,

I have a problem and I hope someone hast the answer.

In the application I have build, there is it possible to change the language (English, German, Dutch).

For this I use an Exelfile DataDict. In the application I use = Only({<Index = {27}>} $(vLanguage)) for

  1. example. Where 27 is the row in de Excelfile with the words in different languages in different columns. In this case “Sales Invoice Document” in English, “Verkaufsrechnung Dokument” in German.

For reports we use N-Printing, we configure the reports in N-printing not in Qlikview.

The problem is this: when we configure a report with tables etc. not the title “Sales Invoice Document” or “Verkaufsrechnung Dokument” (as in the application) is printed but = Only({<Index = {27}>} $(vLanguage)).

Is there a solution? Without using static names and titles?

  1. PS. I have to say, in my other jobs as Qlikview Developer I never used N-Printing for developing reports, only for printing and sending with mail, the reports were made in Qlikview. And I only had applications with one language.

4 Replies
passionate
Specialist
Specialist

Hi Van,

This is weird but,

what i can understand from this is that =Only({<Index = {27}>} $(vLanguage)) is not evaluated.

try debugging by assigning this to variable and then evaluating this by $(Variable).


Regards,

Pankaj

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Are you using NPrinting 17?

NPrinting 17 is not supporting "always one selected value" which i believe you have in you language selection field. it also clears all selections prior to report generation

  • Try to apply filter on your language field (in NPrinting) !
  • this will only work when generating report - it will not work in preview!

cheers

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
pacoli2013
Creator
Creator
Author

Thanks,

I will test it

Regards Court

marcostucki
Contributor
Contributor

Hello

I am facing the same problem as Pacoli2013. We use Qlik Sense February 2022 Patch 1 (14.54.4) and NPrinting Mai 2022 SR3 (22.15.11.0).

We aim to enable an On-Demand Pixel Perfect report based on a Multilanguage App which we crated according the following blog: (https://community.qlik.com/t5/Design/Making-a-Multilingual-Qlik-Sense-App/ba-p/1678131)

In the App, everything works fine and we can change the Language with the ONLY Formula pretty easy. But when it comes to NPrinting, there are some problems:

1. The NPrinting on-Demand Pixel Perfect Report always failed, when changing the language from german (default in the load script) to english: This was because of the Field value and Variable value in the load script. NPrinting had an empty result after changing the language. Due to this, we did not set a Field value but only a Variable containing the language. In the app, this works fine with the variable-input control. Now, no error occures anymore when creating an On-Demand Pixel Perfect Report. But the translations with the Only Formula did not work in NPrinting Pixel Perfect...

Can anyone tell me the best practice with Multilanguage in NPrinting?

- How the tables in Qlik Sense need to be prepared to get proper Results in NPrinting?

- How the tables needs to be bound in in NPrinting Pixel Perfect?

Thank you very much for your help!