Previous Time in Bar Chart

Tue, 10 May 2011 12:59:28 GMT

Hi,

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).

Any ideas how to do that ??

Thanks !!!

Re: Previous Time in Bar Chart

matt_crowther — Tue, 10 May 2011 13:39:24 GMT

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.

Start looking around the 'above()' function.

Hope that helps,

Matt - Visual Analytics Ltd

topic Re: Previous Time in Bar Chart in QlikView

Previous Time in Bar Chart

Re: Previous Time in Bar Chart