how to load single dashboard data into excel by using macros

[srikanth99]

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 ?

[arvind1494]

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

[MindaugasBacius]

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]

Hi Avind,

            Need whole data from the qvw

[srikanth99]

Thank you Bacius

will try

[srikanth99]

Hi Arvind,

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

[arvind1494]

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]

No Idea arvind

[arvind1494 · Accepted solution]

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