topic Visable Cue in formula in Pivot table in QlikView

Visable Cue in formula in Pivot table

francisvandergr — Tue, 14 Oct 2014 10:18:18 GMT

In my pivot table i have the following dimensions:

Article

Article.Minimum

Ì have a formula in my expression:

RangeSum(Before(

Sum(Besteladvies.HuidigeVoorraad)+Sum(Besteladvies.AantalIngekocht)- Sum(Besteladvies.AantalLeveren)

,0, ColumnNo()))

What i want is when the sum of my formula is lower then my article.minimum i wanna have another Colour. Is this possible ?

Anonymous — Tue, 14 Oct 2014 10:35:21 GMT

Hi,

you can expand your expression, then click on Text Color. Here you can type a color expression, for example:

if(column(1) < Article.Minimum, RGB(X,Y,Z)

use the column number for your expression.

Best regards

Stefan

Tue, 14 Oct 2014 10:35:58 GMT

Click on + button of your expression

Click on Font

In right side write this condition

If (Your Expression< xxx, RGB (a, b, c), RGB (a, b, c))

Hope this helps.