Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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.