inyeartodate function

geogou1973 — Wed, 18 Dec 2013 13:43:10 GMT

Hello.

I have the below expression in a chart to compare the current with the previous month.

You have to choose the year current and previous and also

you have to choose the month

Sum(if (InYearToDate (date_id, Today(), 0), sales)) for current sales by now

Sum(if (InYearToDate (date_id, Today(), 0), sales)) for previous sales for the period that the current sales has

For example that compares the 1/12/2013-17/12/2013 with the 1/12/2012-17/12/2012

If the month is completed the expression will compare the hole month

The issue i have is that i want to compare the sales for the current and the previous year and the month for the maximum

hour. How can i do this ? I tried this

Sum(if (InYearToDate (date_id,max(hour), Today(), 0), sales))

but nonthing

topic inyeartodate function in QlikView