Discussion board where members can get started with QlikView.
Hello i'm trying to visually identify groups of repeating numbers in a flat table by alternating the colour each time a number changes like so:-
ive tried to use this script under 'change background colour' in dimension tab:-
=if(mod(BP,2),rgb(135,206,255),rgb(84,255,159) this doesnt quite work, seems to have a mind of its own, I would like to achieve this each time a number changes.
Maybe you want to try something similar Matt has demonstrated here:
u can try below code
Click on + sign before expression
text color of expression
if(BP=below(BP) or BP=above(BP),rgb(135,206,255),rgb(84,255,159))
BPmay be columnname or expression whatever you are taking
hope this helps
This does look good, however its spitting out loads of nulls now for field BP as this field is a calculated expression which loads relative to date in another table as such:-
if([Created On BW]>[Created On Date CMP],BP)
How do I fix this? im not quite understanding why your field above is causing nulls
use Expression label in place of BP In 
I'm sorry, you've lost me there... How is this different to your previous post?
for expression if([Created On BW]>[Created On Date CMP],BP) you have Expression Label Name is BP
then You can use like below
if([BP]=below([BP]) or [BP]=above( [BP]),rgb(135,206,255),rgb(84,255,159))