Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
lidita09
Contributor
Contributor

PIVOT TABLE EXPORT TO EXCEL ISSUE

error from excel export.GIFpivot from app.GIF

 

Hello,

 

I am experiencing an odd issue when exporting my data to excel from my local Qlikview app.

 

My pivot looks like the attached initial photo and when exported the column OMW date is being duplicated in the measure column  like in the second attachment that is the pivoted column as a text value. if anyone can please advise if they have experience this and if there is a way to fix it.

 

2 Replies
shiveshsingh
Master
Master

Could you explain it more?

lidita09
Contributor
Contributor
Author

Yes, I have a pivot table with a date before the pivoted column. In my example the pivoted column is the Measure and the date from the column to the immediate left is showing up on the measure column when exporting to excel.