topic Automatic transpose when export to Excel in QlikView

Automatic transpose when export to Excel

agrisyst — Thu, 26 Nov 2009 15:39:19 GMT

Hello all,

I am not an expert and I could use some help on the following:

When exporting a table to Excel, I would like to transpose the data before they are exported to Excel. I know how to transpose in Excel but would like to do this in QlikView so the whole proces is easier and faster?

Would anybody know how to do this are maybe have a Macro for this....

Regards,

Marc

Automatic transpose when export to Excel

Fri, 27 Nov 2009 17:41:45 GMT

In your macro for export to excel

first set the Straight table properties as below

TableProperties.Horizontal = true

this will make the table as transposed

now copy this table and export to excel

after this again change the properties of the table as below

TableProperties.Horizontal = false

this will roll back the table to its original state

regards

peter