Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
its the default nature of excel , we don't have any control on that.
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.
Hi Shane/Aaron,
Did you get any solution to this. I am facing the same issue.
Regards
Did you get it solved??
I'm stuck with same issue any help is appreciated.
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.