topic Re: copying expressions to a new pivot table in QlikView

copying expressions to a new pivot table

becki_kain — Wed, 25 Nov 2020 16:16:04 GMT

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

becki kain

Re: copying expressions to a new pivot table

MK9885 — Thu, 02 Nov 2017 20:19:48 GMT

Not sure if this would help but you can hit

Crtl+Alt+V

this would open a box for Expression overview....

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.

Re: copying expressions to a new pivot table

oscar_ortiz — Thu, 02 Nov 2017 20:33:05 GMT

Becki,

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.

Good luck

Oscar

Re: copying expressions to a new pivot table

becki_kain — Fri, 03 Nov 2017 18:53:59 GMT

thanks. its ctl alt e but what I didn't realize was the label column. I just set that. will that save the number formatting though?

Re: copying expressions to a new pivot table

MK9885 — Fri, 03 Nov 2017 18:56:39 GMT

If both the expression are same yes it will.

But the image I posted is helpful only to export all your Expressions and from Text file you can copy expressions easily and create new expressions.