Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
rish_sai
New Contributor III

Qlik Sense exporting Pivot table to excel as below format

Hello,

I have created Pivot table in qlik sense when i export to excel  I want to merge first two columns into single columns and export. Is there any possible for doing this 

Qlik Report :
Qlik Pivot Table.PNG

 

 

Export Excel:


Export Excel Output.PNG

User required in below format:

Requried.PNG

Is there possible creating this type of data model in back end script .

 

Thanks you advance.