13 Replies Latest reply: Dec 27, 2016 6:12 AM by Mandar Sansare RSS

    NPrinting Cell Justification for Excel reports

    Shane Michelon

      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?