Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Pivot table: set color of value in ColumnA depends on value in ColumnB

hi friends,

is it possible to set behavior of value in column "A" on pivot table to following rules?:

- pivot table (chart object)

- dimensions: year, month, business case (string), deliverable (string)

- expressions: weighted total (in €), total (in €), invoicing probability (in %)

if value "invoicing probability" in row is less than 100 (%), I would want to set color (font) for value "weighted total" to RED. Else value will have GREEN font.

very thanks for tips

4 Replies
Not applicable

Pivot table: set color of value in ColumnA depends on value in ColumnB

Hi Juraj,

You can try this.

Go to Expression Tab and expand the expression "invoicing probability" and write the expression in Text Color like

= IF( Sum(InvAmount) > 100, Red(), Green() )

Regards,

Raj Kishor

Not applicable

Pivot table: set color of value in ColumnA depends on value in ColumnB

Hi Kishor,

it doesn't work. I need following behaviour:

I think that I must to this in tab "Visual Cues" or no?

I try followings (set on expression "ColumnA"), but no does work also:

IF([ColumnB]*[TotalAmount]<[TotalAmount],Red(),Green())

IF([ColumnB]<100,Red(),Green())

IF([ColumnB]<'100%',Red(),Green())

some other tip please

Not applicable

Pivot table: set color of value in ColumnA depends on value in ColumnB

Hello!

insted of 100 use 0.1

may be tht works ......

Not applicable

Pivot table: set color of value in ColumnA depends on value in ColumnB

Hi Kishor,

very thanks. It's my mistake.

It does work! Super!