Skip to main content

Qlik NPrinting

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
meetmrudul
Creator II
Creator II

Talk Time in NPrinting

Hello All,

We have a field called Talk Time in QlikSense Application which is in Seconds.

When we convert the same in HH:MM it works fine in QlikSense, but when same we fetched in NPrinting, it does not work.

Any idea.

How we can convert numbers to HH:MM format in Qlik NPrinting, Pixel Perfect Report.

Regards,

MK

2 Replies
Ruggero_Piccoli
Support
Support

Hi,

You could:

- create a new calculated field in the original Qlik Sense object that exports the field as text. I suggest this because the perfermace in report generation time are the best

- create a calculated field in the PixelPerfect template. Use the PixelPerfect formula editor to create the expression. Note that the calculation will be don for each line in each report you generate so it is slower than the previous solution

Add Calculated Field.png

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
meetmrudul
Creator II
Creator II
Author

I have number of seconds coming from QlikSense, and want to convert the same into HH:MM format.

I was able to find the calculated field in NPrinting, but not able to find the function which can be used for same.

Please assist.