Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
gagan_bhasin1
Contributor II
Contributor II

How to transfer multiple sheet objects to excel with functionality intact?

I am trying to shift a multibox and a pivot table from QlikView to MS Excel. I am able to transfer the data and at times have drop downs using macros, but the functionality is not traveling. Any suggestions are most welcome.

tamilarasu‌ If we can do this using macro, can you help me with how to implement that code? I'd be grateful for your help.

10 Replies
mdmukramali
Specialist III
Specialist III

mdmukramali
Specialist III
Specialist III

Hi,

AFAIK  you want same functionality also in the Excel then i think you have to Qlikview OCX Control.

i think i tried this one long back.

Thanks,

Mukram.

tamilarasu
Champion
Champion

Hi Gagan,

Do you want the same kind of multibox in excel as well? Excel has it's own functionality and I think we can implement pivot table (excel version) and combo box as alternative. I have not tried Qlikview OCX control before.

marcus_sommerHave tried this before? Your advice is greatly appreciated. Thank you.

marcus_sommer

Some years ago I tried to use qlikview-objects in MS office but I didn't get it to work. To this time no books and no community was available - and if look today there are nearly no postings to it and less what seems to have worked. Therefore I doubt that it was ever a reliable feature.

I would go in this case a different way by creating all necessary functionalities natively in excel itself (which aren't directly available then per vba) and than just updating/replacing the data behind them. This meant something like this:

- copying an qlikview table into a (hidden) excel-sheet

- building an excel-pivot on top of this data (with a dynamic cell-area over an offset() expression in a name)

- then just replacing these data with a routine

- Marcus

tamilarasu
Champion
Champion

I completely agree with you. Actually, I thought exactly the same thing . But I was wondering whether If you have tried this before. Gagan wants to implement native Qlikview functionality, so thought of asking you before answering anything. Thanks Markus. Enjoy your rest of the day!

tamilarasu
Champion
Champion

Hi Gagan,

If you can prepare excel template file like Marcus suggested, I can help you to update the excel file. Please let us know your thoughts.

gagan_bhasin1
Contributor II
Contributor II
Author

‌Hi Mukram,

Thanks For the prompt reply. Can you please elaborate on Qlikview OCX Control?

Thanks,

Gagan

gagan_bhasin1
Contributor II
Contributor II
Author

Hi Marcus,

Thanks for your reply.

WIll that lead to a dynamic update? It has to be designed in a manner that user just click on let’s say a button object on the dashboard and gets the objects in excel.‌

Thanks,

Gagan

gagan_bhasin1
Contributor II
Contributor II
Author

Hi Tamil,

Thanks a lot for actively handling this query and involving Marcus as well. I will give it a go. It would be great if you may elaborate more on preparing the template. Also, many have suggested the use of Qlik  Nprinting to achieve the same functionality. As I have never used it, I am not sure it will be workable or not. May you please suggest something regarding this?‌

Thanks,

Gagan