YTD Calculation

[#1]

I am counting the number of units sold per month with the formula:

sum({<MonthNum={$(=Max(MonthNum))}>}[Units Solds])

that mean if I selected several months in first chart, QlikView provides the data for the latest month and this works perfectly.

In a second chart, I'd like to display the YTD units sold and I was expecting that the following formula should do it:

sum({<MonthNum<={$(=Max(MonthNum))}>}[Units Solds])

but it is not processing. Any help is welcome.

Pierre

[Gysbert_Wassenaar]

Try this: sum({<MonthNum={"<=$(=Max(MonthNum))"}>}[Units Solds])

[er_mohit]

Hi

Try this

sum({<MonthNum={'<=$(=Max(MonthNum))'}>}[Units Solds])

[#4 · Accepted solution]

Hi Gysbert,

thanks for your quick reply. I just moved the " before the first } to get

sum({<MonthNum={"<=$(=Max(MonthNum))"}>}[Units Solds])

and it went fine. so it's a case closed.

Thanks and regards,

Pierre