topic Re: Qlik Sense NPrinting - Date Fields in App Development

Qlik Sense NPrinting - Date Fields

gbarrett — Fri, 21 Apr 2017 13:56:03 GMT

Hello,

I am creating my first Pixel Perfect report and am bringing in 2 date fields from my app. Within my Qlik Sense script, I am applying Date() and Floor() functions to both fields. Using the fields within a Detail Report they are coming through as numbers and not dates. I tried creating a calculated expression with the GetDate() function and that just returned nothing. When changing the format to Date Time, rather than it return a date in the format specified it returns the literal string that is selected in the format type (returned "MM/dd/yy" for every row). How do I format a date field in Pixel Perfect. Thanks in advanced.

Re: Qlik Sense NPrinting - Date Fields

dwforest — Thu, 17 Aug 2017 17:38:04 GMT

I have the same issue.

I've seen some references to using a script, but not how.

I've also seen formatting the date in Qlik to make it a string; this is not really viable as I need the value to be a date in the application for other things to function. Besides, date formatting should work in NPrinting; its a pretty basic feature...

Re: Qlik Sense NPrinting - Date Fields

gbarrett — Thu, 17 Aug 2017 17:48:26 GMT

I raised this issue via the Qlik Support portal. It is a known bug and they are working on correcting it. A workaround is to create a formula in Pixel Perfect with this syntax: =text(date(Date_Field,'MM/DD/YY')). Hope this helps for the time being.

Re: Qlik Sense NPrinting - Date Fields

dwforest — Thu, 17 Aug 2017 18:00:25 GMT

Tried that and get an error... Custom function 'text' not found

Using Nprining June 2017 with QlikSense on a Pixel Perfect report

Re: Qlik Sense NPrinting - Date Fields

gbarrett — Thu, 17 Aug 2017 18:05:38 GMT

Are you using it in a formula in the Designer? Not in the formatting for the field, you have to create a specific formula.

Re: Qlik Sense NPrinting - Date Fields

dwforest — Thu, 17 Aug 2017 18:13:30 GMT

No, was trying to do it as a Calculated Field.

Works as formula. Thanks!

Re: Qlik Sense NPrinting - Date Fields

kdmarkee — Wed, 18 Oct 2017 20:45:40 GMT

And I can confirm this is still an issue in Sep 2017 NP, but this post was helpful for me as well to learn a work around.

Re: Qlik Sense NPrinting - Date Fields

millerhm — Wed, 18 Mar 2020 14:34:36 GMT

This is still an issue for me in 2020 and it's infuriating to basically have to duplicate everything as a text(date()) string to get it to display correctly in NP when there is a a built in formatting string that does not work.

In my case, I have a date in a table, so I can't create a Formula - anyone else figured this out?

Re: Qlik Sense NPrinting - Date Fields

PK007 — Mon, 21 Jun 2021 08:28:58 GMT

Still an issue in 2021. Also have a date within a table, so cannot use the work-around mentioned in this thread. @millerhm have you figured this out yet?