Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.


Filling Cells when exporting pivot to Excel

tried posting earlier, but did not seem to work. Sorry if this is a duplicate

I have 2 development PCs. both W7, 64x, both with 9SR7. One of my apps on PC1 I have had in development a number of years, and is available to users via the QV server using the IE plug-in. The other PC2 is just for quick and dirty data cleaning and analysis. Here is the difference: when I export from the app on PC1 the cells form the Pivot table are NOT filled in Excel. Whereas my app from PC2 always fills the cells when exporting pivot to excel.

I would like to be able to control this but do not know where the setting is. I have looked through user and document preferences and also looked at the object settings. I cannot figure it out.

Can someone help?