I have a Bar Chart with Time (month and Year, like 'Dec 2010', 'Jan 2011', 'Fev 2011' and so on) as Dimension in X Axis.
For the color of the Bars, I need an expression for the Sum that uses 2 previous Dates for calculation.
Heres an example:
If the bar is in 'Jan 2011', for its color the Sum in the expression must use data from 'Jan 2011', Dec 2010' and Nov 2010'.
The field I use for this dimension in X is AnoMes (built with the union of Year and the number of the Month. For example: 'Jan 2010' corresponds the value 201001 for the AnoMes).
Look into using the 'Chart Inter Record' functions (Search the Help file) even though you're working with a Bar Chart the underlying Qlikview chart driving it is a Straight Table which is the case for all objects apart from Pivots that behave differently.
