topic Datatype issue in NPrinting in Qlik NPrinting

Datatype issue in NPrinting

jasmina_karcic — Thu, 26 Jul 2018 10:48:33 GMT

Hi experts,

I am using NPrinting and Qlik Sense, april 2018 version.

In Qlik Sense application I created table. In two columns I have number values with formating:

So, I don't have in Qlik application decimal places.

When I imported this table in Qlik NPrinting editor template, I unchecked, for all table: Keep source format.

Then, I created table in NP Editor, where I put 3 columns with formating:

After that, I take result:

(column1- from qlik sense) (column2- from qlik sense) column3 (calculated column in nprinting: column1-column2)

97 792 97792 -1

How is this possible?

97792-97792=0 not -1.

When I export this template in xlsx....I see in column1 (in formula bar):

97 791.5

Instead of 97 792.

Where is problem???

Kind regards,

Jasmina

Re: Datatype issue in NPrinting

Lech_Miszkiewicz — Thu, 26 Jul 2018 23:48:56 GMT

problem is that you are not rounding values, you are only changing how they are displayed - therefore your result is still different than 0 and when applied format on it, it is equal 1

If you want ot remove decimal places all together you will need to apply Floor function on top of your current expressions in Qlik

cheers

Lech

--------------------------------------------

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.

Re: Datatype issue in NPrinting

jasmina_karcic — Fri, 27 Jul 2018 09:27:13 GMT

Hi Lech,

floor (97 791.5) will give 97 791

ceil (97 791.5) will give 97 792

But I need, for value<97 791.5 it returns me 97 791, but when value>97 791.5 it returns 97 792.

How can I make this?

thanks

Re: Datatype issue in NPrinting

Lech_Miszkiewicz — Fri, 27 Jul 2018 09:35:17 GMT

Use ROUND function

Details around this function are on help.qlik.com and all parameteres are described there