topic How to transfer multiple sheet objects to excel with functionality intact? in QlikView

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

gagan_bhasin1 — Wed, 10 Jan 2018 12:24:35 GMT

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.

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

mdmukramali — Wed, 10 Jan 2018 13:14:29 GMT

Hi,

follow the below Link.

QlikTip #32: Exporting multiple QV objects to a single Excel document

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

mdmukramali — Wed, 10 Jan 2018 13:21:51 GMT

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.

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

tamilarasu — Wed, 10 Jan 2018 15:10:42 GMT

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_sommer‌ Have tried this before? Your advice is greatly appreciated. Thank you.

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

marcus_sommer — Wed, 10 Jan 2018 15:38:30 GMT

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

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

tamilarasu — Wed, 10 Jan 2018 16:27:33 GMT

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!

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

tamilarasu — Wed, 10 Jan 2018 16:30:55 GMT

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.

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

gagan_bhasin1 — Wed, 10 Jan 2018 17:13:33 GMT

‌Hi Mukram,

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

Thanks,

Gagan

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

gagan_bhasin1 — Wed, 10 Jan 2018 17:16:34 GMT

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

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

gagan_bhasin1 — Wed, 10 Jan 2018 17:21:03 GMT

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

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

marcus_sommer — Thu, 11 Jan 2018 08:00:48 GMT

Yes, I think it could be dynamic.

The routine would need to check if the excel is already opened and if they must give a message that the excel must be closed and after this they could be called again. Or the data are kept outside from the excel-dashboard maybe within another excel or some csv and the dashboard would use them as data-source.

- Marcus