Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
(NPrinting 17.22 + QSense)
Hi,
I have a weird problem with NPrinting Graph . I am trying to build a graph that uses axis "X" as time (Years) called "año_factura" and "Y" as the measure "Sum(ValidoMailing)/Sum(ICC)" from a Qlik Sense Table
The NPrinting PREVIEW Mode pop ups an Error Message.
Input String was not in a correct Format.
BUT, if I try build a graph with same X dimension año_factura and instead of the calculated formula Sum(ValidoMailing)/Sum(ICC) I take just Sum(ValidoMailing) or Sum(ICC) then it works: as below:
X Axis | Y axis | QSense Table / Graph | NPrinting Table | NPrinting Graph | ||
---|---|---|---|---|---|---|
Año_factura |
| OK |
| OK | ||
Año_factura | Sum(ICC) | OK |
| OK | ||
Año_factura | Sum(ValidoMailing)/Sum(ICC) | OK | OK | Input String Incorrect Format. |
Any Help. I have tried to save the excel file as .csv but it get worse and none value is displayed in Nprinting Graph, but NPrinting tables works.
Download Data Source; Excel File
Hi Dear Luis
Your problem is because on the measure you have Null values