Maybe I haven't fully understood what you are trying to achieve, do you want to export the contents of e.g. a straight table chart that you've created in the frontend to a file?
If so, right click on the chart and use Export... where you can export your table data into a file using several formats, like Excel, txt, or qvd.
no, that's not what I want to do. That would be an alternative to have the result data of a specific diagram, but it cannot be run automatically, one has to open the document to do that manually.
Instead, I want to use JOINs to gather all the fields one diagram uses into one table, replacing all set_identifiers and other filters used by the diagram by WHERE clauses in the LOAD and then use a STORE command to save it as a result_qvd.
In another document (the overarching management-dashboard), I then load just this qvd and I can display the core message of one diagram.
I guess there is no easier way, I have to combine all the fields necessary into one table using so many JOINs or MAPs. That means an enormous amount of trial-and-error as JOINs can be quite tricky, but I guess it's possible.
Thanks for helping anyway!