Excel Export from Qlikview Dashboard

[pandiarajan]

Dear All,

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

[pradosh_thakur]

Hi

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.

[pandiarajan]

is there any option to clear selection in Macro Code itself?

[pradosh_thakur · Accepted solution]

May be this will work.
ActiveDocument.Fields("FieldName").Clear

or
ActiveDocument.ClearAll true -- this will clear everything


I will advice you to avoid macro if possible.