Can you explain to me this expression:

Tue, 20 Dec 2011 14:18:49 GMT

I have this expression in a straight table:

Sum({$<Year={$(=Only(Year)-1)}>} Sales)

I cannot get this syntax (the underline one)

Thanks in advance

Can you explain to me this expression:

Anonymous — Tue, 20 Dec 2011 14:23:21 GMT

if variable Yaer = 2011 is the sum of sales for year 2010

Re: Can you explain to me this expression:

swuehl — Tue, 20 Dec 2011 14:28:22 GMT

$(=Only(Year)-1) is a dollar sign expansion, so it will evaluate the expression contained and it will be replaced with the result before the sum(... Sales) is evaluated.

Only(Year) will return the possible value from field Year, but only if there is only one possible value (i.e. you have actively selected one year or limited to one possible by selecting on other fields). You could also use max(Year) to always get a value returned, though results are different to only(year) if there are multiple possible values.

Then you deduct 1 from the Year value, giving the year number prior the possible value.

So if today's year 2011 is the only possible value, it will expand to

Sum({$<Year={2010}>} Sales)

Hope this helps,

Stefan

topic Can you explain to me this expression: in QlikView

Can you explain to me this expression:

Can you explain to me this expression:

Re: Can you explain to me this expression: