topic About automatic send to Excel in QlikView

About automatic send to Excel

Thu, 14 Apr 2011 11:40:21 GMT

Hi.

I have implemented a pivot chart with data expandable or squeezable. But when I use the send to Excel as a feature of the chart, into Excel I can see the "photo" of my data: in Excel I cannot to expand or compress the dimensions.

Any suggests for me, please? Thanks

About automatic send to Excel

gauravkhare — Thu, 14 Apr 2011 11:54:29 GMT

Hi there,

Please can you be more precise on what exactly the problem you are facing....you can see 'photo' of your data????????.

Please dear state a bit more clearly..I' am saying all this because it never happened with me.The moment I click on the send to excel icon, qlikview starts exporting the data.

Ok tell me about the volume of your data and if possible kindly mail a screen shot of the same.

About automatic send to Excel

Thu, 14 Apr 2011 12:05:50 GMT

Hi.

I have a pivot chart with some dimensions and one measure. My data are organized with a parent-child hierarchy. In the pivot chart I can expand or compress my data with the + (plus) symbol. When in the chart all my data are compressed, I see a general total: if I click to send to export to Excel, in the sheet I can see this general total but I cannot to navigate into my data by expanding them.

Now, is it more clear the question? Many thanks.

About automatic send to Excel

nathanfurby — Thu, 14 Apr 2011 15:37:00 GMT

QlikView doesn't export a pivot table into Excel. It just sends the current cell data to Excel.

If you want to send all data to Excel you need to right-click on the chart beforehand and click Expand All. then export to Excel.

You will not be able to expand/collapse in Excel unless you create another pivot table in Excel.

About automatic send to Excel

erichshiino — Thu, 14 Apr 2011 15:37:08 GMT

the 'Export to Excel' will only send numbers and texts (similar to copy as value).

This will not recreate a pivot table automatically. So, you will not get a dynamic excel pivot table with formula (total, sum, etc) or the ability to expand/collapse the dimensions.

Alternatives:

- Export the QlikView object to Excel

- Write a macro to export a table and recreate the object there.

Regards,

Erich

About automatic send to Excel

Thu, 14 Apr 2011 15:42:43 GMT

It'a pity that a pivot isn't entirely and automatically exported to Excel.

Thanks

About automatic send to Excel

nathanfurby — Thu, 14 Apr 2011 15:50:30 GMT

They are two entirely different objects. Only way would be to write a macro to export the raw data and then create a pivot table in Excel from that data. I can't see QV adding that kind of functionality anytime soon.