i have 4 pivot tables, in qlik and i need to concatenate them together, 2 and 2. the expressions can be very complex and though i enter the number format i wanted for all the numbers , in settings->document properties, I'm having to set them for each expression, manually. is it possible to "pick up and copy" each expression that i want to move out of each of the original 4 pivot tables or do i have to open each expression, manually, copying the label, the format, and the expression itself, into the final pivot tables? thanks
Here you see all the expressions used in the app, you can EXPORT the expressions to a text file from there and it might be easier to hop between text file and qvw file rather than opening a chart, copying, closing, opening, pasting, closing....repeat ...
There might be more easier way than what I've said...plus you can edit the expression(s) from this box itself.
You can try right clicking on the expression and clicking copy from one chart and then go to the expression tab of the other chart right click (you may need to scroll to the end of your expressions) on an empty space of the left panel and paste the expression.
Your column labels and all of your formatting should be applied.