1 Reply Latest reply: Jan 24, 2012 7:32 PM by Stefan Wühl RSS

    How to Change the Text or Background Color of a field in a Table or Pivot Table?

      I have absolutely no idea how to do this in Qlikview.  No matter what I try nothing works.  I'm to the point of giving up on this tool and it's frustrating because I can't get any work done.

       

      I need to change the background color of a field.  I would also like to bold the text in said field.  How, and where, do I do this?

        • How to Change the Text or Background Color of a field in a Table or Pivot Table?
          Stefan Wühl

          You could enable View->Design Grid

          Then right click a cell in the column you want to change color / Text style for and select from context menu Custom Format Cell.

          This dialog should be quite easy to use.

           

          You can also apply style changes using attribute expressions. You find the attributes if you click on the plus sign next to the dimensions / expressions in dimension and expression tab. Select e.g. background color and enter as expression a color expression, e.g.

          =black(10)

           

          Another way is to use visual cues from the Visual cues tab in chart properties, e.g. to highlight certain values.

           

          Hope this helps,

          Stefan