Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
oakes_gco_qlik
Contributor III
Contributor III

Chart with values by month - how to take one moth value away from previous


Hi I posted something similar a while back but got no response - may be the question wasnt clear enough or maybe its not possible?.

I have a bar chart of values for each month. I wish to take the next months value away from the current month and display it as another column for the current month.

In the attached example two columns for each month.

Requirement is  Jan 2274(A)    minus feb 2004(A)  to give third colum under Jan-2014 showing 270 (column C?)

Feb 2004(A)  minus Mar 1790(A)  to give third colum under Feb-2014 showing 214(Column C?).

Note (B) is irrelevant to this requirement.

Any ideas ? ANY help on this would be appreciated even if it means going back to the script to add more code in.

0 Replies