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.
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.
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
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!
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 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?