Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
berryandcherry6
Creator II
Creator II

formating column values in pixelperfect Nprinting

Hi,

I have a table with columns, but for single column it getting value displayed as -0  for every row of column. where actual calculated value will be -0.0546, -0.459 like so....

But i need it to display in percentage wise  like -5.46%, -45.9% ...

How could i apply formatting for this particular column?

1 Solution

Accepted Solutions
harishkumarg
Creator III
Creator III

Hi

The format of the column can be changed by following steps,

1. Select the column and click on the arrow highlighted in black in the below image.

Image1.PNG

2. Select Format String and click on the one highlighted in the below image.

Image2.PNG

3. Select Percent.

Image3.PNG

Hope this helps!

Regards

Harish

View solution in original post

9 Replies
harishkumarg
Creator III
Creator III

Hi

The format of the column can be changed by following steps,

1. Select the column and click on the arrow highlighted in black in the below image.

Image1.PNG

2. Select Format String and click on the one highlighted in the below image.

Image2.PNG

3. Select Percent.

Image3.PNG

Hope this helps!

Regards

Harish

harishkumarg
Creator III
Creator III

Hi Supriya

Did this work?

Regards

Harish

Daniel_Jenkins
Specialist III
Specialist III

Hi Supriya,

If your data is in columns why are you using formulas? Can you share your project? Take a look at the attached example.

HTH - Daniel.

berryandcherry6
Creator II
Creator II
Author

Hi daniel,

  I am not using columns, using expression through fx.

formula:

if(metric=invitations,sum(invitation),meric=Landing page hits, sum(landingHits)))

Regards,

Supriya

Daniel_Jenkins
Specialist III
Specialist III

Hi Supriya,

It will save a lot of time and effort if you create and share a sample project (NSQ, QVW & Template file).

Best,

Daniel.

berryandcherry6
Creator II
Creator II
Author

Hi,

I have attached template npx file,Please have a look into it, if need any more information please ask

Daniel_Jenkins
Specialist III
Specialist III

Hi Supriya,

Just the npx file will not help. At a minimum we also need the QVW and the name of the object(s) used in the template.

- Daniel.

berryandcherry6
Creator II
Creator II
Author

Hi Harish,

Thanks for reply.

I figured out, why your answer was not working.

I was using formulas in Expression, and putting that in column. here the wrong i was doing is that, my expression was

text(if(metric=invitations,sum(invitation),meric=Landing page hits, sum(landingHits)))).


the text() function in expression, avoiding format string in column. So after removing text() and applying format string as you showed giving the result.


Now, if data is 0.99340 it gives me 99.3% How could i make it to display 9.93%, by applying format string.

berryandcherry6
Creator II
Creator II
Author

Hey Daniel,

Sorry for taking your time, i figured out what was wrong, it was all in expression i was using text() which was used for formatting so it was overiding applying format string through smart tag.

Here i am using qliksense and Nprinting 17.2,so in NPrinting i am not able to use table object, as we do in images or fields. For this, as a workaround, my colleague found solution through levels(to take dimension through INLINE LOAD through Qliksense) and adding Expression.

Is there wrong assumption we have done regarding pulling table object not possible in nprinting using qliksense?  your response will be very helpful for us.