Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
luisccmm
Creator
Creator

NPrinting + QSense: Graph Error/Bug

(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 AxisY axisQSense Table / GraphNPrinting TableNPrinting Graph
Año_factura
Sum(ValidoMailing)
OK
OK
OK
Año_facturaSum(ICC)OK
OK
OK
Año_facturaSum(ValidoMailing)/Sum(ICC)OKOKInput 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

1 Reply
marcos_herrera
Partner - Creator III
Partner - Creator III

Hi Dear Luis

Your problem is because on the measure you have Null values