14 Replies Latest reply: Jun 3, 2015 10:40 AM by Adam Gao RSS

    Conditional Text Color expression values

    Adam Gao

      Dear all,

      I need to solve a problem.I’ve racked my brain to finish it.It seems difficult to me.

      Thanks in advance.

      I've a detail table like this.

      PERSONYMPRODUCTFLAG
      ADAM201401A1
      ADAM201401B2
      ADAM201401C3
      ADAM201401D1


      I want to create a pivot table in qlikview like this (with conditional text color demands):

      PERSON201401
      ADAM

      A,D

      B

      C

      As in this pivot table PRODUCT

           with Flag equals 1 font color is red

           with Flag equals 2 font color is blue

           with Flag equals 3 font color is green


      If it's possible to achieve in qlikview ?(Thank you very much).