Hi Everyone,
I am new to Qlik and have been trying to figure out how to analyze GL transactions. I am trying to create a master calendar using the Qvc components script. The problem is that the only fields that I have to use currently are period, year, accounting period (formatted as MM-YYYY), and the transaction date. The problem with using the transaction date is that sometimes due to month-end activities, the trx date and the accounting period don't always align.
I tried creating a date using the period, year and then arbitrarily creating a day using the last day of each month. This though, probably isn't the best way to do this considering the last day of each month won't always be the same due to leap year. I could possibly code a workaround for that, but I was going to throw the question out there to see if there are any easier ways to do this.
Any help is greatly appreciated, thanks!
