Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

Community Browser