Functions within Set Analysis

Fri, 01 Feb 2013 10:32:09 GMT

Hi,

I have a table that reports monthly figures. Some of the measures report a number of months behind.

I have a column for each measure which is a number. I would like to use ths number on my calculation.

I was using a number of IF statements e.g.

IF(ReportMonth=0,

NUM(SUM( {$<Metric={'z'}>} Data),'0.00%'),

IF(ReportMonth=-1,

NUM(SUM( {$<Metric={'z'},Month={$(vPreMonth)>} Data),'0.00%'),

IF(ReportMonth=-2,

NUM(SUM( {$<Metric={'z'},Month={$(vPreMonth2)>} Data),'0.00%'))))

The problem with this is that I have to code for each possiblitly

What I would like to do is this:

SUM( {$<Metric={'z'},Month={"$(=Date(AddMonths(vMonth,-1),'MMM'))"}>} Data)

But replace the -1 with 'ReportMonth'. This works with I hard code the number.

Any help would be great,

Cheers

Simon

topic Functions within Set Analysis in QlikView