Exporting to Excel Sheet??

[MuraliPrasath]

Hi Qlik Team,

I've a issue with exporting pivot table to excel spread sheet.

I've a 2 dimensions namely Line Item & Period. but I don't have to display the Period on Excel since it is showing the empty column.

On QlikView it displays like below.

On Excel Sheet it displays like below one new column. Which I don't want to send the report like this to Customers. I just want to ignore the Period Num column.

Any solutions will be helpful for me. For reporting I'm using NPrinting to do it.

[jaimeaguilar]

Hi,

maybe you can use a island/orphan table and use it as filter for showing/hidding columns in your pivot table before exporting to Excel. You can do this, by setting a show condition to every dimension in your pivot table,

take a look at the attached example,

regards

[Clever_Anjos]

Please rename your column using spaces at "label" input

[ToniKautto · Accepted solution]

Please notice that the QlikView object is a Pivot table, and that the PeriodNum column is a pivoted dimension in your chart. The PeriodNum label has then been truncated in the QlikView object, but is expanded to readable length by Excel.

Naturally QlikView can not determine your intention of wanting to remove the dimension in Excel, so it must be exported by QlikView to Excel. The only way you can remove it, is by removing it in Excel.

As suggested above you can rename the dimension label in QlikView to "blank"m but the column will still be part of the excel export as the dimension is still in the chart.

For more advanced and customized reporting you might be able to find a solution by using QlikView NPrinting.

http://www.qlik.com/us/explore/products/qlikview/nprinting