topic Dynamic QlikView Reports in MS Office Docs in QlikView

Dynamic QlikView Reports in MS Office Docs

Tue, 05 Nov 2013 14:33:01 GMT

Hello,

I was given a demonstration of functionality whereby a QlikView object such as a chart could be dragged and dropped into an MS Office document and then the report is able to be updated dynamically within the MS Office.

I've tried replicating that functionality myself but it doesn't currently work.

What setup such as Excel add-ins etc do I need to complete to get this to work? (I'm on V10.0)

Thanks

Re: Dynamic QlikView Reports in MS Office Docs

danielrozental — Tue, 05 Nov 2013 20:13:28 GMT

I'm not an expert at this but I believe you need to have the QlikView OCX installed for it to work.

Re: Dynamic QlikView Reports in MS Office Docs

Wed, 06 Nov 2013 13:39:39 GMT

Thanks Daniel - I'll take a look at that

Scott Beange

Project Manager, CDO

Royal Bank of Scotland Group

Strategy & Architecture

149 Preston Rd, Brighton, BN1 6AS, UK

Office: +44 (0)1273 543 171 | Internal 23543171 | Mobile: +44 (0)7867

800 947

Email: scott.beange@rbs.co.uk

Re: Dynamic QlikView Reports in MS Office Docs

rustyfishbones — Wed, 06 Nov 2013 13:58:58 GMT

Hi Scott,

What I did to get this to work, I right clicked on a Qlikview Object like this

I then opened an Excel spreadsheet and and right clicked like this and hit Paste Special

I was then asked to choose to paste as, I chose HTML and clicked OK, and that worked

Re: Dynamic QlikView Reports in MS Office Docs

Wed, 06 Nov 2013 15:58:53 GMT

Thanks Allan, that is useful to know.

I think the issue in my case may relate to the fact we're not yet

running QlikView on the Enterprise Server and that we need certain

services running in order to embed the objects in the MS Office docs.

Best regards

Scott

Re: Dynamic QlikView Reports in MS Office Docs

rustyfishbones — Wed, 06 Nov 2013 17:03:48 GMT

Hi Scott,

It works for me and I am using a single license, no Enterprise server, no Small Businees Edition Server and no Publisher

Regards

Re: Dynamic QlikView Reports in MS Office Docs

Thu, 07 Nov 2013 08:59:02 GMT

Thanks Alan, that's good to know.

Re: Dynamic QlikView Reports in MS Office Docs

Thu, 07 Nov 2013 09:02:02 GMT

Hi Alan,

I meant to ask what version are you on?

Best regards

Scott

Re: Dynamic QlikView Reports in MS Office Docs

rustyfishbones — Thu, 07 Nov 2013 11:23:23 GMT

Hi Scott,

QlikView 11.20 SR2

Regards

Alan