I am creating a pivot table through a macro after making some selections which act as the dimensions.
The macro works fine when run on the server but when trying to run on IE, the pivot table is created but it is all black in color making it unreadable, even if i send it to excel, the font and the background color is black
You are absolutely right - the manual DOES say you should avoid changing the properties of objects in macros when running the document with QV Server. However, everyone does it and I am not aware of it ever causing any problems.
Having said that, I avoid it whenever possible and indeed you should also avoid macros too if possible (for example create multiple objects where only one is displayed using display conditioning based on variables rather than changing properties).
That's interesting... Thank you very much for this answer. I'll rely on you for this "everyone does it" then.
I understand macros should be avoided in order to keep things simple mainly. But official point of view is really scarry as if macros can't be stable or something.
The main reason is that macros cause inefficiencies - caches are cleared and so on as Qlikview cannot know what you are up to with your code. I have attached a document from Qliktech which should give you more details why macros should be avoided if possible.
i am facing on exacly the same problem. I want to build a pivot table depending on the selections, my users made on another sheet. There should be different Buttons, where you can choose, how you pivot table should look like and which dimensions and expressions are used. Perhaps you can help me, to find a solution: How do you remove the existing fields and adding new fields in an already existing Pivot table?
