topic Re: NPrinting Cell Justification for Excel reports in Qlik NPrinting

NPrinting Cell Justification for Excel reports

shanemichelon — Thu, 07 May 2015 06:35:26 GMT

Hi. I have a situation which I think is fairly common.

I have a straight table in Qlikview and I am using it for a report in NPrinting.

The expressions are all set to right justify for text and numeric in Presentation.

In the expression, I have it displaying text if there is no data:

=if(Sum(Amount)=0,'No Sales',Sum(Amount))

When I use this is NPrinting for an excel report, the numeric cells are right justified, but the text cells are left justified.

Any idea on how to fix this?

Re: NPrinting Cell Justification for Excel reports

avinashelite — Thu, 07 May 2015 06:38:47 GMT

Hi Shane,

This is the default nature of XL, we cannot change it . hey if your using the that qlikview object in the NPrinting template this will not cause because it will take the Qlikview object property alignment

Re: NPrinting Cell Justification for Excel reports

shanemichelon — Thu, 07 May 2015 06:42:37 GMT

Thanks for the quick response. I'm not sure I fully understand your answer. Can you elaborate a little please?

Re: NPrinting Cell Justification for Excel reports

danieloberbilli — Thu, 07 May 2015 06:52:53 GMT

as a trick you could use dual() to let Qlik and Excel interpret your text as number:

if(Sum(Amount)>0, Dual('No Sales',0),Sum(Amount))

Re: NPrinting Cell Justification for Excel reports

danieloberbilli — Thu, 07 May 2015 06:53:18 GMT

and numbers are aligned to the right by default

Re: NPrinting Cell Justification for Excel reports

avinashelite — Thu, 07 May 2015 07:01:37 GMT

Your writing the condition( =if(Sum(Amount)=0,'No Sales',Sum(Amount)) ) in NPrinting or Qlikivew ??

If your using the expression in NPrinting then push this condition to Qlikview and in the chart properties align all the data to required format. While developing the Excel template in NPrinting . Don't have condition here , directly added the object build in Qlikview.

Hope this helps you .

Re: NPrinting Cell Justification for Excel reports

shanemichelon — Thu, 07 May 2015 07:15:17 GMT

The expression is in Qlikview.

Re: NPrinting Cell Justification for Excel reports

shanemichelon — Thu, 07 May 2015 07:19:27 GMT

Unfortunately, this just results in the report showing a '0' rather than the text.

Re: NPrinting Cell Justification for Excel reports

avinashelite — Thu, 07 May 2015 07:29:14 GMT

Have you aligned the data in Qlikview?? I mean in qlikview are you aligned the text and numbers to right alignment or in Qlikview also your seeing text in left and number in right?

Re: NPrinting Cell Justification for Excel reports

morganaaron — Thu, 07 May 2015 07:32:59 GMT

I've also found that when aligning labels (dimension or expression) that nPrinting doesn't follow the alignment that I've used in Qlik - for example centring the labels in Qlik ends up with them left aligned (default text alignment) when pushed through nPrinting into excel.

Any answer appreciated!

Re: NPrinting Cell Justification for Excel reports

avinashelite — Thu, 07 May 2015 07:35:03 GMT

its the default nature of excel , we don't have any control on that.

Re: NPrinting Cell Justification for Excel reports

morganaaron — Thu, 07 May 2015 08:33:52 GMT

I'm passing the item to nPrinting and selecting 'keep source format' - which it's not doing. You can tell excel how to align things, including labels, so to me this is an error/bug and so I disagree, we should have control over that.

Re: NPrinting Cell Justification for Excel reports

neha_sri — Tue, 26 Jul 2016 10:42:55 GMT

Hi Shane/Aaron,

Did you get any solution to this. I am facing the same issue.

Regards

Re: NPrinting Cell Justification for Excel reports

Anonymous — Tue, 27 Dec 2016 11:12:09 GMT

Did you get it solved??

I'm stuck with same issue any help is appreciated.

Re: NPrinting Cell Justification for Excel reports

Anonymous — Thu, 28 Sep 2017 19:23:22 GMT

This can be fixed by ignoring the source code in the properties tab for the individual tables. It'll ignore that it identifies it as a character and your report will be centered.