calculating based on two different measures

amien — Wed, 08 Jun 2011 16:46:40 GMT

i have this pivot chart:

2 dimensions:

1 expression :

IF(dimension1 = 'first',

SUM({<base = {actual}>} Value1),

'XXXXXX')

For the XXXXX i want a different calculation .. XXXXXX should be the SUM of Value2. The problem with Value2 is that is not on a period level, but on a period YTD level. This while Value1 is on period level. So, i should convert this.

In a seperate chart, i'm using this expression:

=if(right(period,2)<>'01',Sum(Value2)-(above(Sum(Value2))),Sum(Value2))

This will give me the correct values ..

but i dont know how i can combine both. copy/past doesnt work.

topic calculating based on two different measures in QlikView

calculating based on two different measures