topic Re: Excel Export Format Issue in QlikView

Excel Export Format Issue

Tue, 03 Sep 2013 05:56:56 GMT

Hi,

How can i retain the same format while exporting to excel ? {Months{dimension} are in vertical rows in excel wheras in qlikview its horizontal column)

This is my qlikview report.

I am trying to export the same in excel.But the format is changed in excel as below:

Re: Excel Export Format Issue

ashwanin — Tue, 03 Sep 2013 06:01:38 GMT

Hi Poornima,

In Excel you will get the same format as you have specified in Chart.

You have to change the Dimensions and Expression in Chart to get the desired output.

rgds

Ashwani

Re: Excel Export Format Issue

tresB — Tue, 03 Sep 2013 06:13:00 GMT

You can try transpose in excel like in screenshot below. Copy the content->Special Paste-> Transpose

Re: Excel Export Format Issue

Tue, 03 Sep 2013 06:13:53 GMT

we dont have any options in qlikview ?

i dont want to change the format in excel

Re: Excel Export Format Issue

tresB — Tue, 03 Sep 2013 07:51:45 GMT

While you are exporting from a qv object to excel, it takes the qv object format. Therefore if you choose to do it in qv, you have to create a chart of similar format and export from there. Otherwise, you might try to achieve the same using a more complex option, macro.