YTD - calculation

[#1]

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]

Hi,

I thing there is missing one closing bracket

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

[mike_garcia]

A dollar sign is also missing

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

Mike.

[#4]

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

[brenner_martina · Accepted solution]

Hi,

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

Variable: varMaxMonth   = Max(MONTH)

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


[#6]

Hi:

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

Hope this helps.

-- NK

[#7]

Thank you!