topic Re: Excel Export from Qlikview Dashboard in QlikView

Excel Export from Qlikview Dashboard

pandiarajan — Sat, 16 Nov 2024 04:29:06 GMT

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

Re: Excel Export from Qlikview Dashboard

pradosh_thakur — Tue, 12 Feb 2019 04:54:27 GMT

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.

Re: Excel Export from Qlikview Dashboard

pandiarajan — Tue, 12 Feb 2019 05:06:25 GMT

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

Re: Excel Export from Qlikview Dashboard

pradosh_thakur — Tue, 12 Feb 2019 05:19:59 GMT

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.