Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Mahamed_Qlik
Specialist
Specialist
‎2018-09-29 05:12 AM

Pivote issue

Hi Expert,

I am facing one issue while exporting pivot table to excel.

I want the result to be seen as in Pivote12 snapshop but currently after export it shwoing me result in Pivote21 snapshots.

Both the snapshots attached.

More clarification- First column is getting expanded in the export excel which I dont want it should show only one value.

Kindly assist.

Labels (1)
Labels
Preview file
4 KB
Preview file
4 KB
743 Views
0 Likes
1 Reply
andrey_krylov
Specialist
Specialist
‎2018-09-29 01:42 PM

Hi, Mahamed. As I know exporting to excel gives you a straight table, not pivot. You can achieve that with a macro or copying a table straight from an application and pasting to excel.

680 Views
0 Likes