topic Re: Formatting the Pivot/Straight table while exporting to excel in QlikView

Formatting the Pivot/Straight table while exporting to excel

Tue, 13 Jan 2015 04:00:35 GMT

Hi,

I have below questions while exporting the Pivot/Straight table to excel .

1) While exporting the table to excel by default Qlik View assigns a name(QvsViewClient.aspx) to excel. can we replace this name with any other name i.e. with straight/Pivot table name it self

2) While exporting the Qlik View Pivot table to excel the dimensions displayed in Bold and the expressions will be displayed in normal font.so i want to make all the fields consistent format

3) In excel the selected filters will also be displying below the table, I want to get rid of these selections in excel. PFA the excel screen shot for the same.

Re: Formatting the Pivot/Straight table while exporting to excel

sushil353 — Tue, 13 Jan 2015 04:42:17 GMT

Hi,

You can write macro for your requirement.

you can find many threads on community related to xl export macro

Re: Formatting the Pivot/Straight table while exporting to excel

jonathandienst — Tue, 13 Jan 2015 05:20:50 GMT

For your point 3 - the filter display is controlled from you User Preferences | Export tab. Uncheck the "On BIFF Exports" and "On HTML Exports" options under "Selection Stamps in Exports".

HTH

Jonathan

Re: Formatting the Pivot/Straight table while exporting to excel

kavita25 — Tue, 13 Jan 2015 05:58:40 GMT

Hi,

Can you please post your macro script you are using to export in excel.

Regards,

Kavita

Re: Formatting the Pivot/Straight table while exporting to excel

Tue, 13 Jan 2015 14:20:34 GMT

Hi,

Thanks for your reposes, as of now am not using any macro, if you have any macro for my requirement, can any one share with me.

Re: Formatting the Pivot/Straight table while exporting to excel

Tue, 13 Jan 2015 16:27:14 GMT

Hi Jonathan,

After Unchecking the options On BIFF Exports" and "On HTML Exports" options under "Selection Stamps in Exports", still am getting my filter selections in Excel.

Re: Formatting the Pivot/Straight table while exporting to excel

jzimolong — Wed, 14 Jan 2015 02:38:06 GMT

Play around with the attached, which runs a vbscript macro on button click. Once you click the button, input a tile name, such as "TestFile", and the macro will export to local C:\ drive with name TextFile.xls