Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
pandiarajan
Creator
Creator

Excel Export from Qlikview Dashboard

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

 

Labels (2)
1 Solution

Accepted Solutions
pradosh_thakur
Master II
Master II

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.
Learning never stops.

View solution in original post

3 Replies
pradosh_thakur
Master II
Master II

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.

Learning never stops.
pandiarajan
Creator
Creator
Author

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

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.
Learning never stops.

View solution in original post