Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

shanemichelon
Contributor

NPrinting Cell Justification for Excel reports

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.

NPrinting Justification Issue.png

Any idea on how to fix this?

14 Replies

Re: NPrinting Cell Justification for Excel reports

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

shanemichelon
Contributor

Re: NPrinting Cell Justification for Excel reports

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

danieloberbilli
Valued Contributor II

Re: NPrinting Cell Justification for Excel reports

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))

danieloberbilli
Valued Contributor II

Re: NPrinting Cell Justification for Excel reports

and numbers are aligned to the right by default

Re: NPrinting Cell Justification for Excel reports

Hi

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 .

shanemichelon
Contributor

Re: NPrinting Cell Justification for Excel reports

The expression is in Qlikview. 

shanemichelon
Contributor

Re: NPrinting Cell Justification for Excel reports

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

Re: NPrinting Cell Justification for Excel reports

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?

morganaaron
Valued Contributor

Re: NPrinting Cell Justification for Excel reports

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!

Community Browser