Highlighting within a table Chart according to a condition

Thu, 10 Oct 2013 08:06:24 GMT

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

topic Highlighting within a table Chart according to a condition in QlikView

Highlighting within a table Chart according to a condition