Just like the pivot / graph / data you can also export the current selection to excel file.
Go to the properties of current selection box- >Caption -> you will see the checkbox named send to excel. Check that box. Click ok.
Right click on current selection box, you will see the send to excel option.
Hope this will help you.
Thanks Kaushik for your reply
What I am looking for is slightly more advanced I think and I am not sure if it can be completed. What I am trying to do is that when somebody exports pivot / graph / data then as part of that process the Selection Criteria is automatically sent to excel aswell. Not to have them having to do two actions. Like a global trigger on the document that when an object is sent to excel it will automatically also send the selection criteria
I am presuming that you would need to use the getcurrentselections() function ?
Is it a response time issue on why you advise not to use a macro. Again apologies very new to this software and any advice is appreciated.
I am not sure if I would be able to write a script to do this but I have found this article and it seems to do what I need. Also the last piece about the Qlikview server and reg key is something that I can allow all users to defacult to
[HKEY_CURRENT_USER \ Software \ QlikTech \ QlikOcx \ Settings 7]
"SelectionStampInBIFFExport" = "1"
Thanks for all of your help