How to include user-entered commentary in an automatically generated Qlik PixelPerfect report?
Hi everyone, I'm currently working on a Qlik PixelPerfect report and would like users to be able to add commentary directly within the app and have that commentary included in the generated report. What I've tried so far:
Added a Variable Input Box to the app. Entered a comment into the variable. Added the variable to the PixelPerfect report template.
When I preview the report manually, the comment is displayed correctly in the report. However, when the app is reloaded and the report is generated automatically and distributed via email, the comment is not included in the report attachment. I'm wondering if variable values entered by users are only stored for the current session and therefore not available during automated report generation. Has anyone implemented user-entered comments in PixelPerfect reports before?
What's the best way to persist the commentary so it's available during scheduled report generation? Should I be storing comments in a data source (QVD, database, writeback table, etc.) instead of using a variable? Are there any specific PixelPerfect Reporting limitations I should be aware of?
Any guidance or examples would be greatly appreciated. Thanks in advance!
You mentioned it already, It's most likely due to the variable only be saved in the current session. You could try using Qlik's write table to add comments and then have them saved before you download the report or have a button that reloads the application and then you could download the report.
Variable Input values are session-specific. They exist only in the user's current session and are not persisted when a scheduled PixelPerfect report is generated. Scheduled reports run in a separate server session during reload/distribution, so user-entered variable values are unavailable.
Variables entered by users are usually session-specific, so scheduled report generation won’t have access to those values. Store comments in a persistent source like a QVD, database table, or writeback solution, then load them into Qlik for PixelPerfect to use. PixelPerfect can display the data, but it doesn’t handle storing user input.
