Skip to main content

Qlik Sense Documents

Qlik Sense documentation and resources.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: REGISTER NOW!

Exporting lists from QMC to Excel

cancel
Showing results for 
Search instead for 
Did you mean: 
shaun_lombard
Creator II
Creator II

Exporting lists from QMC to Excel

Attachments

I stumbled upon this feature while trying desperately to simply get a list of items displayed in the QMC exported into an Excel spreadsheet. If there are other simpler methods, please let me know.

The tip requires OneNote and Excel and Internet Explorer (Other browsers not tested)

If you have any questions let me know.

Shaun

Comments
william_fu
Creator II
Creator II

You're a legend!

0 Likes
xufei123
Partner - Specialist
Partner - Specialist

Don't know why can reply to Shaun directly hence do it here.

This doesn't work for me?

And if I use print, it print the screenshot as an image to OneNote...

Any idea?

Thanks

Fei

0 Likes
shaun_lombard
Creator II
Creator II

I am using IE 11 and OneNote 2016, are you using the same versions?

0 Likes
xufei123
Partner - Specialist
Partner - Specialist

Yes, I am using IE 11.64.16299.0 and OneNote 2016.

0 Likes
shaun_lombard
Creator II
Creator II

I have seen a recommendation to change the value of the following registry key from 1 to 0

HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\User Settings\OneNoteToIEAddin

Change "Count" from 1 to 0 and then restart the machine.

Mine is currently set to 1 and is working fine.

0 Likes
xufei123
Partner - Specialist
Partner - Specialist

Thank you for your effort Shaun.

I have made this change and restarted my PC but still have the same error.

Cheers.

Fei

0 Likes
jeremy_fourman
Creator
Creator

Thank you, this worked well for me today.

nilekp2019
Partner - Contributor II
Partner - Contributor II

Hi everyone, It's easy to use you can do it via monitoring app as provided by Qlik.

0 Likes
nilekp2019
Partner - Contributor II
Partner - Contributor II

In monitoring app relevant fields and then export it as excel.

 

Shisho_Karsenty
Contributor III
Contributor III

Another "quick and dirty" way is to "print"(right-click -->"print") your QMC list and save it as a PDF.
Then you can copy-paste text from PDF to excel.
As I mentioned dirty but quick (:

Version history
Last update:
‎2016-07-25 08:39 PM
Updated by: