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
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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

769 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

386 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?

386 Views
0 Likes