Discussion Board for collaboration on QlikView Layout & Visualizations.
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
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() )
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:
some other tip please
insted of 100 use 0.1
may be tht works ......
very thanks. It's my mistake.
It does work! Super!