Discussion Board for collaboration related to QlikView App Development.
I would like the month & year (e.g. Apr 2016) to be serialized where each month increases by 1. So for example, if my data starts from Oct 16, the serial field should look like this:
How can this field be created? Thanks.
Try it with: autonumber(MonthYear) as MonthYearSeriell
Edit: For this you will need a sorted load which is already quite common by using a master-calendar.
View solution in original post
If(MonthYear = Date#('Oct-16','MMM-YY'),
1+ Year(MonthYear)*12+Month(MonthYear)-(Year(Date#('Oct-16','MMM-YY'))*12+Month(Date#('Oct-16','MMM-YY')))) as ID
Date#(MonthYear,'MMM-YY') as MonthYear