topic Re: YTD Calculation in QlikView

YTD Calculation

Wed, 29 Apr 2015 08:46:46 GMT

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 — Wed, 29 Apr 2015 08:51:07 GMT

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

er_mohit — Wed, 29 Apr 2015 08:56:05 GMT

Try this

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

Wed, 29 Apr 2015 09:08:18 GMT

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