If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a numeric field like this for a date: 202101 , 202102, 202103, 202104, which formula can I use to reveal the current month?
Date(Date#([Date Field], 'YYYYMM'), 'MMM')
Using 'MMM' in the Date function will return Jan, Feb, Mar, Apr for the dates listed in your example. To return just the number (e.g., 01, 02, etc.) change 'MMM' to 'MM'
To define the current month just wrap the above expression in Max()
Max(Date(Date#([Date Field], 'YYYYMM'), 'MMM'))
View solution in original post