Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
becki_kain
Contributor III
Contributor III

copying expressions to a new pivot table

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

4 Replies
MK9885
Master II
Master II

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.

Untitled.png

oscar_ortiz
Partner
Partner

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

becki_kain
Contributor III
Contributor III
Author

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?

MK9885
Master II
Master II

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.