1 Reply Latest reply: May 24, 2017 8:28 PM by Lech Miszkiewicz RSS

    NPrinting question - cell multi-formatting

    Martin Cooper

      Hi

       

      We've been trying to find a way to format some data in QV as part of an NPR report output which has multiple values and requires custom colouration within a single cell. 

       

      It's part of an overview grid to show Costs/ Revenue values against plan for an attribute (e.g. department) and is to replicate a legacy report before we can move over to a new QV centric layout.

       

      The tolerances can vary depending on department and their cost-types and some other things, but would generally be:

       

      Red means > 10% behind plan

      Blue means <= 10% behind or ahead of plan

      Green means > 10% ahead of plan

       

      The required output is this:

       

      npr_custom_cell_formatting.png

       

      We can't find a way to have multiple colours within a single cell in the pivot table, so can't do the formatting upfront in QV, so are hoping there is a way to do this in NPR.

       

      We concatenate the data at source so we have used sum/aggr/concat to create a string to parse in QV or NPR, which has an intended target colour included, so:

       

      npr_custom_cell_formatting_raw.png

      The final document needs to be in PDF format, so an Excel NPR template outputting a PDF or a Pixel Perfect report is required.

       

      There are other ways to do this in QV no doubt, but this is part of a large org output to go on one-page report beside other charts.

       

      Any ideas on how to approach this would be appreciated!

       

      We are using QV12.0 and NPrinting 17.3.  The NPrinting server has a full version of office installed and is on separate hardware from the QVS/QVP services.

       

      thanks

        • Re: NPrinting question - cell multi-formatting
          Lech Miszkiewicz

          Hi,

           

          It may be bit more development but...

           

          What if you could split your cell valueas into 3 like this:

          1.png

           

           

          In XLS template then you coule merge cell for "Period 1" header and have each cell formated separately.

           

          Then you would just create boundries around designed cells and remove grid print

           

          like this

          2.png

          then print it to PDF

           

          woudl that solve your problem?

           

          cheers

          Lech

          ---------------------------------------------

          When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.