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

how to load single dashboard data into excel by using macros

srikanth99 — Wed, 25 Nov 2020 16:16:04 GMT

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 ?

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

arvind1494 — Tue, 24 Jul 2018 05:13:06 GMT

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

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

MindaugasBacius — Tue, 24 Jul 2018 05:36:38 GMT

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

create alerts in qlikview

QlikView App: Send Data In QlikView Alerts

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

srikanth99 — Tue, 24 Jul 2018 06:32:03 GMT

Hi Avind,

Need whole data from the qvw

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

srikanth99 — Tue, 24 Jul 2018 06:32:38 GMT

Thank you Bacius

will try

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

srikanth99 — Tue, 24 Jul 2018 08:49:52 GMT

Hi Arvind,

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

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

arvind1494 — Tue, 24 Jul 2018 09:23:08 GMT

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

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

srikanth99 — Tue, 24 Jul 2018 09:38:50 GMT

No Idea arvind

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

arvind1494 — Tue, 24 Jul 2018 10:02:44 GMT

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

Again go to Control+M

and test SendReport