Our Existing Qlikview dashboard which already in production, we have set the trigger on open default current Year & Current Month. At the same time, we have created Excel Export Macro from one of the sheet in the same dashboard but we need to export Current Year data. we already apply sheet trigger to clear the selection but while export the excel it exporting only current month data. I have schedule window Task for export excel from the dashboard
As you have said you have selected current year and current month using trigger , the selection will be feb 2019. I think it's giving you the correct data only. If you don't select the month hopefully it will give you the correct result for the entire year.