Help needed with a set analisys !!

Thu, 15 Apr 2010 16:32:59 GMT

Hi:

I'm trying to make a simple bar chart with X=time dimension (years) and Expression = Difference between "Sales Current Year - Sales Previous Year".

By example:

year 2000 --------> Sales $100

year 2001 --------> Sales $250

year 2002 --------> Sales $600

So I want get for:

year 2001 -------> $150 ($250 -$100)

year 2002 -------> $350 ($600-$250)

and so on...

I´ve tried with this set expression:

sum([Sale]) - sum({$<Year={$(#Year -1 )} > }[Sale])

but $(#Year -1 ) becomes in a empty string or in some cases (lightly variants) in 0 (zero).

Could any help me !

Very thankful

Thu, 15 Apr 2010 16:36:53 GMT

Hi,

try this:

Sum(Sale)-above(Sum(Sale))

Alex

Thu, 15 Apr 2010 16:56:32 GMT

Perfect !!!

Clearly this is the easyest way!

Thankful!

Pablo

topic Help needed with a set analisys !! in QlikView