Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have exported a Straight Table to Excel via a macro script. The problem is, one of the fields is a percentage field
but I am having problems with the formatting.
Currently in QlikView it looks like this: 15.1% but as soon as I export the Straight Table the field percentage display as 15.10% in
Excel. I want the formatting in Excel also to be displayed as 15.1%. (As soos as Excel sees the field as percentage, it automatically
formats it to two decimal places).
I am unable to use the Copy to Clipboard function in QlikView because I am exporting more than one table onto one Excel Sheet.
I am looking for a way from within the QlikView macros to be able to set the Excel Decimal places for Percentage to 1.
Thanks very much.
Just code the necessary macro to reformat the column?
The code will be along the lines of
Columns(1).NumberFormat = "#,##0.0%"
If you cant get qlikview to do what you need, then you can create an excel template with thew macro in it.
When you export, you open the template and use that then just call the macro from Qlikview
Just code the necessary macro to reformat the column?
The code will be along the lines of
Columns(1).NumberFormat = "#,##0.0%"
If you cant get qlikview to do what you need, then you can create an excel template with thew macro in it.
When you export, you open the template and use that then just call the macro from Qlikview
Hello this was very helpful.
I tweaked it a little bit, but it definitely put me on the right track.
I used :
range(VarName). NumberFormat = "##,#0.0%"
Thank you
No worries at all, I am glad it put you on the right track