Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Support Case Portal will move to Qlik Community Oct 4. Temporary case outage Oct 3. READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

Format issue

Hi all

i am facing one issue regarding number format

i am created a excel report in nprinting ,,, in my qliksense application stright table measure coloumns are  number format

but after creating reports  in result template  it is showing  number converted to text .

hence values are not coming in related tables in template.

1 Solution

Accepted Solutions
kakaderanjit53
Creator III
Creator III

Hello,

Kindly implement the following number format after deselecting the "keep source format" option under properties of object/element;

  

NameStyle
format.Integer#,##0
format.Decimal#,##0.00
format.Money$#,##0.00
format.Percentage#,##0.00%
format.ShortDateDD/MM/YYYY
format.LongDateWWWW, MMMM DD, YYYY
format.Timeh:mm:ss TT
format.TimestampDD/MM/YYYY h:mm:ss[.fff] TT

View solution in original post

4 Replies
kakaderanjit53
Creator III
Creator III

Hello,

Kindly implement the following number format after deselecting the "keep source format" option under properties of object/element;

  

NameStyle
format.Integer#,##0
format.Decimal#,##0.00
format.Money$#,##0.00
format.Percentage#,##0.00%
format.ShortDateDD/MM/YYYY
format.LongDateWWWW, MMMM DD, YYYY
format.Timeh:mm:ss TT
format.TimestampDD/MM/YYYY h:mm:ss[.fff] TT

View solution in original post

Chanty4u
MVP
MVP
Author

still no luck bro

woutermak
Partner
Partner

You can change your cell format in Excel.

number.PNG

mkelemen
Creator III
Creator III

Hi,

17.3.1 was released yesterday and it fixes following bug:

Custom formats ignored on cells

Jira issue ID: OP-4037

If you added cells with the Keep source format flag deselected, and a custom format specified, Qlik

NPrinting ignored the custom format and displayed the numbers with scientific notation.

Not exactly what you are experiencing but it is worth a try.

BR,

  Matus