Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

berryandcherry6
Contributor 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
Contributor III

Re: formating column values in pixelperfect Nprinting

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

9 Replies
harishkumarg
Contributor III

Re: formating column values in pixelperfect Nprinting

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
Contributor III

Re: formating column values in pixelperfect Nprinting

Hi Supriya

Did this work?

Regards

Harish

Employee
Employee

Re: formating column values in pixelperfect Nprinting

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
Contributor II

Re: formating column values in pixelperfect Nprinting

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

Employee
Employee

Re: formating column values in pixelperfect Nprinting

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
Contributor II

Re: formating column values in pixelperfect Nprinting

Hi,

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

Employee
Employee

Re: formating column values in pixelperfect Nprinting

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
Contributor II

Re: formating column values in pixelperfect Nprinting

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
Contributor II

Re: formating column values in pixelperfect Nprinting

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.

Community Browser