Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

srikanth99
New Contributor III

how to load single dashboard data into excel by using macros

Hi Team,

       I have dashboard with 2 kpi's, need to extract data into 1  excel by using Macros. How to do it ?

       Is there any other alternative method ?

1 Solution

Accepted Solutions
Highlighted
arvind1494
Valued Contributor

Re: how to load single dashboard data into excel by using macros

after creating table use reference of that table i.e Id likr TB01

hen press control+m

write following code into macros:

Sub SendReport

ActiveDocument.Sheets("SH01").Activate 'edit the sheet

'ActiveDocument.reload

set objExcel=ActiveDocument.GetSheetObject("TB03") 'edit the sheet object

strDate = Year(Date()) &"-"& month(date()) &"-"& Day(Date())

filepath="D:\Macros\Excel_"&strDate&".xls"   'edit the location of file

objExcel.ExportBiff filepath

ActiveDocument.GetApplication.Sleep 5000

End Sub

Click on  Ok

Now press Control+Shift+M

Chose give system control access

Ok

Again go to Control+M

and test SendReport

8 Replies
arvind1494
Valued Contributor

Re: how to load single dashboard data into excel by using macros

Do you want whole data or only data from KPI's ?

MindaugasBacius
Valued Contributor III

Re: how to load single dashboard data into excel by using macros

Alerts might be the solution as you only need to show two numbers:

create alerts in qlikview

QlikView App: Send Data In QlikView Alerts

srikanth99
New Contributor III

Re: how to load single dashboard data into excel by using macros

Hi Avind,

            Need whole data from the qvw

srikanth99
New Contributor III

Re: how to load single dashboard data into excel by using macros

Thank you Bacius

will try

srikanth99
New Contributor III

Re: how to load single dashboard data into excel by using macros

Hi Arvind,

                 Please let me know how to extract whole qvw data into excel

arvind1494
Valued Contributor

Re: how to load single dashboard data into excel by using macros

Create one table and add all fields into that table.

after that create one macro to export this table into excel.

if you don't know how to create macro then please let me know

srikanth99
New Contributor III

Re: how to load single dashboard data into excel by using macros

No Idea arvind

Highlighted
arvind1494
Valued Contributor

Re: how to load single dashboard data into excel by using macros

after creating table use reference of that table i.e Id likr TB01

hen press control+m

write following code into macros:

Sub SendReport

ActiveDocument.Sheets("SH01").Activate 'edit the sheet

'ActiveDocument.reload

set objExcel=ActiveDocument.GetSheetObject("TB03") 'edit the sheet object

strDate = Year(Date()) &"-"& month(date()) &"-"& Day(Date())

filepath="D:\Macros\Excel_"&strDate&".xls"   'edit the location of file

objExcel.ExportBiff filepath

ActiveDocument.GetApplication.Sleep 5000

End Sub

Click on  Ok

Now press Control+Shift+M

Chose give system control access

Ok

Again go to Control+M

and test SendReport