Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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
Author

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
Author

Hello!

insted of 100 use 0.1

may be tht works ......

Not applicable
Author

Hi Kishor,

very thanks. It's my mistake.

It does work! Super!