Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-05-09 05:01 AM

conditional formatting using macro

Hi All,

I am exporting pivot tables to excel and I have few negative values in pivot which are enclosed in brackets without - sign in my QVW file. Now when I export this pivot table to excel, brackets are getting removed and - sign is coming. Please suggest how to add barckets in excel using GetProperties method.

I have tried to get the solution from API guide but it is very confusing and I need this solution urgently. Please help.

Thanks,

Kirti

806 Views
0 Likes
2 Replies
Not applicable
‎2012-05-09 05:41 AM
Author

Also, my text is getting wrapped automatically when exported to excel. I want column width same as my QVW file in excel too.

Please suggest syntax using GetPorperties method.

Thanks,

Kirti

423 Views
0 Likes
m_woolf
Master II
Master II
‎2012-05-09 08:18 AM

Why not run a macro in Excel that changes the format to the desired appearance?

423 Views
0 Likes