topic Re: Indirect set analysis in QlikView

Indirect set analysis

Anonymous — Mon, 03 Dec 2012 11:38:20 GMT

Hi,

This expression calculates Recovery

SUM(PAY_AMOUNT) - Sum ({<PAY_DR_YEAR = P(SALES_DR_YAER)>}PAY_AMOUNT)

now i want to break down the resultant figure into it's actual year of recovery or even if possible previous months

I tried this for the year

SUM({$<Year = {'=$(=Max(Year)-1)'}>}PAY_AMOUNT) - Sum({$<Year={'=$(=Max(Year)-1)'},PAY_DR_YEAR = P(SALES_DR_YAER)>}PAY_AMOUNT)

but the results was'nt right.

Any Help?

MEllinghausen — Mon, 03 Dec 2012 11:49:13 GMT

Hallo,

try this one

SUM({$<Year = {"$(=Max(Year)-1)"}>}PAY_AMOUNT) - Sum({$<Year={'"$(=Max(Year)-1)"},PAY_DR_YEAR = P(SALES_DR_YAER)>}PAY_AMOUNT)

Marcus

Anonymous — Mon, 03 Dec 2012 12:05:17 GMT

Hi Marcus

I noticed it returned the same value as the general recovery expression.That can't be possiblle

MEllinghausen — Mon, 03 Dec 2012 12:17:48 GMT

Have you clear your selections? e.g. month??