How to fetch data for previous 60 business days, 24 month ends and 7 year ends
Hi,
I have a requirement where the report should have data for last 60 business days, 7 year ends and 24 month end dates. I have already created a load script that helps load recent 60 business days.
As I am new to qlik sense, I will need your suggestion on the best approach to implement this.
I am thinking of adding one load statement that loads 60 business days and 7 year ends. For 7 year ends, I will create 7 variables and use them in match statement.
For 24 month ends, I will create another load statment which loops through 24 month end dates to fetch the data.
I will then concatenate the data loaded from both load statements above. Is this an inefficient approach?
