topic help me with sparkline chart in QlikView

help me with sparkline chart

Thu, 29 Oct 2009 17:53:16 GMT

i tried to export sparkline chart to excel sheet . but in excel it stores it as a image. is there a way where we can export it as an object . meaning that any changes made in data exported to excel , gets dynamically reflected in sparkline chart too

help me with sparkline chart

vidyut — Thu, 29 Oct 2009 17:57:28 GMT

Hi Archana,

It is not possible, at least as I know it. Using MS-Office Integration, If you use QlikVIew objects in Excel, it should be possible though.

help me with sparkline chart

Thu, 29 Oct 2009 18:06:04 GMT

hi vidyut ,

can u pls explain , what u mean by Ms Office Integration??? and how to do it

help me with sparkline chart

vidyut — Thu, 29 Oct 2009 20:37:31 GMT

In Version 8.5 onwards, you could drag and drop QlikVIew Objects in MSOffice Applications - PPT/Excel etc, and as it is the object embedded in Excel, you could see the charts changing with your selections.

I never got it working on my copy of office though! but have seen it working in some other environment.

help me with sparkline chart

Fri, 30 Oct 2009 22:52:21 GMT

I am having the same problem... (using Excel 2003 SP3).

Is there any plug-in/add-on required to get this working?

help me with sparkline chart

Fri, 30 Oct 2009 23:57:34 GMT

With a little bit of research I found out that you need the QlikView IE plug-in (as specified in help function of Windows product).

I only have an evaluation version of QV 9.0.

The plug-in seems to require QuickView Server, which (I assume) is not available in the free version of the product QV?

Too bad, because the drag&drop of objects from QV to Office-suite is really a nice feature and demonstrated in the introductory courses.

Can somebody confirm that this functionality is not available in the free version?

Thanks