topic Re: YTD - calculation in QlikView

YTD - calculation

Wed, 15 Jun 2011 11:48:32 GMT

Hi,

I loaded budgetdata from a cross table but when I try to make the YTD the result is 0.

This is the set analysis I used: Sum({$<MONTH={"<=(=max(MONTH)"}>} BudgetAmount).

I used a similar formula in other Qlikview-documents and had no problems.

Any suggestions for solving this problem?

Thanks in advance.

brenner_martina — Wed, 15 Jun 2011 11:50:42 GMT

Hi,

I thing there is missing one closing bracket

Sum({$<MONTH={"<=(=max(MONTH))"}>} BudgetAmount).

mike_garcia — Wed, 15 Jun 2011 12:03:12 GMT

A dollar sign is also missing

Sum({$<MONTH={"<=$(=max(MONTH))"}>} BudgetAmount)

Mike.

Wed, 15 Jun 2011 13:51:25 GMT

Thanks for correcting my set analysis-formula but this still doesn't work.

brenner_martina — Wed, 15 Jun 2011 15:11:46 GMT

Hi,

ok, than try to enter a variable, that's always better:

Variable: varMaxMonth = Max(MONTH)

Sum({$<MONTH={"<=$(varMaxMonth)"}>} BudgetAmount)

Wed, 15 Jun 2011 15:43:02 GMT

Hi:

Month is a character variable. Try with MaxString instead of Max

Hope this helps.

-- NK

Thu, 16 Jun 2011 06:57:32 GMT

Thank you!