Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

gbarrett
New Contributor III

Qlik Sense NPrinting - Date Fields

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.

6 Replies
dwforest
Valued Contributor

Re: Qlik Sense NPrinting - Date Fields

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...

gbarrett
New Contributor III

Re: Qlik Sense NPrinting - Date Fields

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.

dwforest
Valued Contributor

Re: Qlik Sense NPrinting - Date Fields

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

Using Nprining June 2017 with QlikSense on a Pixel Perfect report

gbarrett
New Contributor III

Re: Qlik Sense NPrinting - Date Fields

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

Sales Screenshot.PNG

dwforest
Valued Contributor

Re: Qlik Sense NPrinting - Date Fields

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

Works as formula. Thanks!

kdmarkee
Contributor III

Re: Qlik Sense NPrinting - Date Fields

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.