topic Re: Displaying reload time NPrinting in Qlik NPrinting

Displaying reload time NPrinting

hammermill21 — Sat, 16 Nov 2024 05:13:21 GMT

Hello,

I have the reload time on my NPrinting Report which is pulled from my Qlik Sense App and to do so I'm using <ReloadTime()>. The problem is that if I remove the "Keep Source Formats" in NPrinting the time comes out as a row of numbers (43420.2995). I need to be able to format the text and size for my report. Is there any other way to pul in the reload date and time from my Qlik Sense sheets?

Thanks!

Re: Displaying reload time NPrinting

Lech_Miszkiewicz — Sun, 18 Nov 2018 22:45:58 GMT

This can be achieved in multiple ways:

1. by enforcing text format in Qlik on ReloadTime() function, like: Text(Timestamp(ReloadTime()))

2. Use NPrinting in template formula like:Timestamp(ReloadTime())

If you still have issues with it, please provide more details how you transfer your Reload time from Qlik Sense. Do you use it as a variable or something else? What format of NPrinting template are you using.

regards

Lech

Re: Displaying reload time NPrinting

JustinDallas — Mon, 19 Nov 2018 15:52:43 GMT

Have you tried formatting the ReloadTime?

Date(ReloadTime())

You can also set the text to be a variable in NPrinting

Or, you can make it a variable in your app and load it that way, but I'm not sure if ReloadTime is calculated at the start of the app reload, or at the end.