topic Email a dynamic ppt in QlikView

Email a dynamic ppt

Fri, 12 Aug 2011 11:35:22 GMT

When i create a powerpoint based on a Qv document i can drill down in the charts etc. on my OWN computer.

When I send the powerpoint to someone else, it looses it's functionality. Is there a way to enable the other person to drill down on the data. Without installing Qlikview.

Thx!

Email a dynamic ppt

Fri, 12 Aug 2011 12:55:48 GMT

http://www.youtube.com/watch?v=RJAA_PKlFw4

This is what i want to accomplish, but in ppt

I hope I don't need to install anything new, bec ause i really want to use it for people who don't have Qlikview, a licence of any special installation!

Email a dynamic ppt

klausskalts — Fri, 12 Aug 2011 13:10:02 GMT

No unfortunately not - PowerPoint "talks" to your QlikView engine - and it's QlikView doing all the work. When you cut the connection to QlikView you also cut the access to QlikView functionality.

The only way to have interaction in PowerPoint is ti have QlikView and the QlikView document available to the user sitting with Powerpoint.

Email a dynamic ppt

Fri, 12 Aug 2011 13:12:42 GMT

So when i want to be able to drag my presentation around the building without taken me own laptop, i'll need to install te Qv Server and have all the reports on it?

That way it would work ...

Email a dynamic ppt

klausskalts — Mon, 15 Aug 2011 08:47:26 GMT

Using QlikView Server is certainly the best solution.

You can log on from any workstation in the network and the data will be automatically updated.

Only you must know that there can be issues with changing screen objects on the fly - you must have Enterprise Edition Server as well as rights to maintain server objects.

Also you can not make changes to the script - should you be in the need of that.

Finally - reload: If you need to reload on-the-fly; this can be done from the Server Control Panel if you have the rights to do so ....

In anycase - I feel QlikView Server is the best solution for users who are logged on to the network.

OK?

Email a dynamic ppt

Mon, 22 Aug 2011 09:27:29 GMT

Thx Klaus,

It's a usefull answer, but not the one I was hoping for.

I need to compete with XCelsius, which has this ability. Isn't there a work-around, it would be a really nice function!

Re: Email a dynamic ppt

Anonymous — Mon, 22 Aug 2011 09:50:12 GMT

Hi,

Check this attached file. macro part.

hope this will help you

sam

Email a dynamic ppt

Mon, 22 Aug 2011 13:05:13 GMT

At this time I'm only using a personal edition, so i can't open the file

Email a dynamic ppt

klausskalts — Tue, 23 Aug 2011 09:32:38 GMT

Hi Deborah

If you want QlikView functionality this is the only solution. QlikTech charges for the use of QlikView (development is for free - as you know from using the Personal version).

Only workaround - which really isn't a workaround - is to print, save or send reports e.g. in PPT-format of static charts, graphs etc. However this will NOT allow your "users" to make dynamic queries etc.

Sorry ........

License options:

Are you aware of the Document CAL option and/or Session CAL option ?

(These options might offer an price-efficient solution to you deployment costs)

OK?

Email a dynamic ppt

udaya_kumar — Mon, 26 Dec 2011 09:39:37 GMT

hi sam,

i can open that qvw file, but where i can find the macro in that qlikview document?

Email a dynamic ppt

udaya_kumar — Mon, 26 Dec 2011 10:00:13 GMT

hi sam,

i got the macros, but you have written such a big macro.

so out of that, which macro name should be used for exporting?

can you please tell which module to use in that?