I was asking myself if there are standard procedures and rules in Qlikview for solving Year, Quarter, Month, Week and Day problems. Reason I’m asking that, is I as programmer/developer love standard procedures/rules for solving problems, it makes life as a programmer/developer much easier.
In Qlikview I see often expressions to filter data. Filters based on Year, Quarter, Month, Week or Day. For example: there is Budget based on year and month and an Actual based on week and day. To compare them you have to bring Actual on year/month level which is much easier as bringing Budget on week/day level (in my opinion).
For year/month filters you can use expressions like: