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