I am using QlikView 11, and need to change the colour of a cell based on the improvement/decline of a customers sales month on month. I've created my chart with Jan, Feb, Mar and Apr
For example, Jan was £1,548, Feb was £747, Mar was £1,160 and Apr was £1,325. The targets set are that Feb needs to be 10% more than Jan, Mar needs to be 10% more than Feb and Apr needs to be 10% more than Mar. If it isn't, go red, if it is go green.