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