I am needing some assistance. I currently have a Fiscal Year Calendar that was used as a Binary for my current application. Within my application, I am wanting to do a YOY comparison for the past 3 years, but only up to today's date in all three years.
Currently, I have the fields
*[Day Number] which is representative of the Fiscal Year Day Number
*FYDay which is in the format of YYYY & Day Number.
With the FYDay being in this format, we will be able to do set analysis with today's max fyday and simply subtract 1000 for last year and 2000 for two years ago, etc.
I have set a variable vMaxDate = Today(0). Now I am stuck with trying to set a variable for vMaxFYDay. Given that the FYDay field is related to the Date field, I thought I should be able to set my vMaxFYDay using the vMaxDate.
I have quite a bit of experience in writing VBA for excel: I would think I am needing an equivalent for INDEX&MATCH. I have attempted using multiple functions within Qlik, but none of them are giving me what I'm needing.
I would truly appreciate any help that I can get in trying to get this figured out! Thanks!