Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Datatype issue in NPrinting

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:

expressions.png

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:

formatcells.png

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: Datatype issue in NPrinting

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.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

3 Replies
Highlighted

Re: Datatype issue in NPrinting

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.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

Highlighted
Creator III
Creator III

Re: Datatype issue in NPrinting

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



Highlighted

Re: Datatype issue in NPrinting

Use ROUND function


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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.