pandiarajan
Creator
2019-02-11
10:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
1,083 Views
1 Solution
Accepted Solutions
pradosh_thakur
Master II
2019-02-12
12:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
ActiveDocument.Fields("FieldName").Clear
or
ActiveDocument.ClearAll true -- this will clear everything
I will advice you to avoid macro if possible.
Learning never stops.
1,068 Views
3 Replies
pradosh_thakur
Master II
2019-02-11
11:54 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
1,075 Views
pandiarajan
Creator
2019-02-12
12:06 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
is there any option to clear selection in Macro Code itself?
1,072 Views
pradosh_thakur
Master II
2019-02-12
12:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
ActiveDocument.Fields("FieldName").Clear
or
ActiveDocument.ClearAll true -- this will clear everything
I will advice you to avoid macro if possible.
Learning never stops.
1,069 Views