Thanks for your reply, but I wouldn´t share hundreds of lines with the expressions and variables. Furthermore you would need to understand the datamodel for optimization. Too much efforts for all.
So coming back to my 2 questions
a) How to trace and get the final, resolved expression?
b) Which tools are available for performance tuning?
If there's only one level of nested variables:
1. Add Text & Image object
2. Add a measure to it
3. Set an expression for the measure enclosed in single quotation marks:
Variable should expand as a text and whole expression will be seen before execution.
4. If there's more expressions, you can compile long expression for Text & image' in excel. For example:
'SUM($(vYourNastyVariable))' & chr(10) & 'SUM($(vYourSecondNastyVariable))'
You can get calculation timings to help with performance tuning using either of these tools.
1) QS Document Analyzer - Search Recipes | Qlikview Cookbook
2) DevTool extension -- https://github.com/erikwett/DevTool
That's an excellent question re seeing the complete expression after dollar sign expansion (resolved expression). Easy to do in QlikView, not sure how to do it in Qlik Sense.