topic Re: formating column values in pixelperfect Nprinting in Qlik NPrinting

formating column values in pixelperfect Nprinting

berryandcherry6 — Tue, 25 Oct 2016 03:27:48 GMT

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?

Re: formating column values in pixelperfect Nprinting

harishkumarg — Tue, 25 Oct 2016 06:43:29 GMT

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.

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

3. Select Percent.

Hope this helps!

Regards

Harish

Re: formating column values in pixelperfect Nprinting

harishkumarg — Tue, 25 Oct 2016 11:17:39 GMT

Hi Supriya

Did this work?

Regards

Harish

Re: formating column values in pixelperfect Nprinting

Daniel_Jenkins — Wed, 26 Oct 2016 06:57:13 GMT

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.

Re: formating column values in pixelperfect Nprinting

berryandcherry6 — Fri, 28 Oct 2016 03:46:10 GMT

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

Re: formating column values in pixelperfect Nprinting

Daniel_Jenkins — Fri, 28 Oct 2016 03:51:47 GMT

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.

Re: formating column values in pixelperfect Nprinting

berryandcherry6 — Fri, 28 Oct 2016 05:55:58 GMT

Hi,

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

Re: formating column values in pixelperfect Nprinting

Daniel_Jenkins — Fri, 28 Oct 2016 06:09:16 GMT

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.

Re: formating column values in pixelperfect Nprinting

berryandcherry6 — Thu, 10 Nov 2016 06:25:14 GMT

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.

Re: formating column values in pixelperfect Nprinting

berryandcherry6 — Thu, 10 Nov 2016 06:47:49 GMT

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.