Discussion Board for collaboration related to QlikView App Development.
Thank you for this.
Let me try it and revert...
I think I just need to amend this slightly so three colours can be produced (red, amber, green).
Is there any way of not fixing the color of the first row?
You used this expression:
=If(RowNo() = 1, RGB(255, 0, 0),
If([Sales] <= vAvgYearlySales, RGB(1* ([Sales]/1000), 0,0), RGB(0, 1* ([Sales]/1000), 0)))
If I delette the bold section, hopping to free the color of the first row QV pop up an error about exceeding the asigned memory...
Try like this
=If(RowNo() = 1, RGB(255, 255, 255),
RGB(255, 255, 255) - White the default color