Datatype issue in NPrinting

[jasmina_karcic]

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

[Lech_Miszkiewicz · Accepted solution]

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.

[jasmina_karcic]

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

[Lech_Miszkiewicz]

Use ROUND function

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