topic Re: copy all the expressions used by objects in QlikView

copy all the expressions used by objects

Thu, 27 Mar 2014 06:18:15 GMT

Hi,

Is there any option to copy all the expression used in objects in one stretch??

jonathandienst — Thu, 27 Mar 2014 06:38:59 GMT

You can export them (to Excel, for example) from the Expression Overview. Go to Settings | Expression Overview or click Ctrl-Alt-E

HTH

Jonathan

Thu, 27 Mar 2014 06:48:20 GMT

hi,

Copy the Object from which u want all the Expression in to the New Qvw File.

Go to SETTINGS - EXPRESSION OVERVIEW here u will get all the Expressions used in the that object then click on

EXPORT and save it. Then u can open that with Notepad. U will get all the List of Expressions.

Hope it Helps.

PradeepReddy — Thu, 27 Mar 2014 07:08:59 GMT

Hi,

We can export all the expressions in the document to excel sheet in 2 steps.

Step-1: From the expression overview (CTRL+ALT+E), we can export the data into 2 formats only.

Either to 'Tab Delimited' format or Text format.

Step-2: Import the data from Tab delimited file to excel sheet.

Data(Excel menu) Menu--> From Text--> File Name --> Delimited(select this option) -->

Tab(select this option)--> Next--> Select all the coloumns--> check the option as Text---> Finish.

If we don't give the option text here, the RGB expression will be calculated and gives invalid value..

Thanks,

Pradeep

Thu, 27 Mar 2014 08:26:55 GMT

I tried this but Expression overview is disabled, how to enable it?

PradeepReddy — Thu, 27 Mar 2014 10:26:07 GMT

I don't know how to enable it... As of my knowledge there is no such options.... May be it will take some time if there are lot of expressions...

Try the below approach.. it will work.... http://community.qlik.com/thread/62483

Today I learnt a new feature...

Regards,

Pradeep

jsingh71 — Thu, 27 Mar 2014 10:32:05 GMT

Go to Settings --> Expression Overview

Then click on export button.

--Jai