0 Replies Latest reply: Oct 10, 2013 4:06 AM by Thomas Walldorf RSS

    Highlighting within a table Chart according to a condition

      Hello could someone help me,

       

      I am new in developing with QlikView. I like to build a table chart (diagramm). In additon I like to highlight special rows or field of an column in red if a condtion occurs.


      I thought it would be able with a formular within a attribute.
      My table has for exampel two columns.


      table:

      ColumnA ColumnB

      a               2

      b               3

      c               1

      d               2

      e               5


      Funktion 1:

      If ColumnA value a and ColumnB >= 2 then highlight the field in ColumB of the same row in red

      If ColumnA value b and ColumnB >= 3 then highlight the field in ColumB of the same row in red

      If ColumnA value c and ColumnB >= 4 then highlight the field in ColumB of the same row in red

      If ColumnA value d and ColumnB >= 3 then highlight the field in ColumB of the same row in red

      If ColumnA value e and ColumnB >= 5 then highlight the field in ColumB of the same row in red

       

      Funktion 2 (show rows according to an condition):

       

      If ColumnA value a and ColumnB >= 2 then show this row in table

      If ColumnA value b and ColumnB >= 3 then show this row in table

      If ColumnA value c and ColumnB >= 4 then show this row in table

      If ColumnA value d and ColumnB >= 3 then show this row in table

      If ColumnA value e and ColumnB >= 5 then show this row in table

       


      I tried to do that within  a formual in ConlumnA:


      If(ColumnA = 'a' and ColumnB >= '2', ColumnA),

      If(ColumnA = 'b' and ColumnB >= '3', ColumnA),

      If(ColumnA = 'c' and ColumnB >= '4', ColumnA),

      If(ColumnA = 'd' and ColumnB >= '3', ColumnA),

      If(ColumnA = 'e' and ColumnB >= '5', ColumnA),

       

      Thanks a lot for help

      Thomas