Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hello,
Kindly implement the following number format after deselecting the "keep source format" option under properties of object/element;
Name | Style |
format.Integer | #,##0 |
format.Decimal | #,##0.00 |
format.Money | $#,##0.00 |
format.Percentage | #,##0.00% |
format.ShortDate | DD/MM/YYYY |
format.LongDate | WWWW, MMMM DD, YYYY |
format.Time | h:mm:ss TT |
format.Timestamp | DD/MM/YYYY h:mm:ss[.fff] TT |
Hello,
Kindly implement the following number format after deselecting the "keep source format" option under properties of object/element;
Name | Style |
format.Integer | #,##0 |
format.Decimal | #,##0.00 |
format.Money | $#,##0.00 |
format.Percentage | #,##0.00% |
format.ShortDate | DD/MM/YYYY |
format.LongDate | WWWW, MMMM DD, YYYY |
format.Time | h:mm:ss TT |
format.Timestamp | DD/MM/YYYY h:mm:ss[.fff] TT |
still no luck bro
You can change your cell format in Excel.
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