Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

how to export expressions from all reports into excel ?

..

5 Replies
Not applicable

Re: how to export expressions from all reports into excel ?

You can go to Expression overview -> export.

load .tab file and make pivot table add all dimension and put expression=1

right click copy entire table and paste in excel.

you will get somewhat better representation and if single expression comes in multiple column then select column and  merge .

Document would not be  perfect  but you can work further in excel to improve it.

Re: how to export expressions from all reports into excel ?

The export file created by the export can be hard to parse when the expression goes to multiple lines. You can get a more structured representation of the expressions from either:

QlikView Governance Dashboard

Document Analyzer at Downloads - Rob Wunderlich Qlikview Consulting

-Rob

http://masterssummit.com

Not applicable

Re: how to export expressions from all reports into excel ?

Hi Snehal

If you are using Qlikview 10, another option would be to generate the project file associated with the dashboard. This is QlikView's version control system and generates a folder containing XML descriptions of all objects associated in the document.

I create the folder, then use a qlikview script to loop back and import information relating to the objects.

To create the project files (in QV10) create a document folder the same name and folder as your dashboard but with the suffix -prj.

EG for dashboards/aDashboard.QVW the folder name would be dashboards/aDashboard-prj/

Next time you reload the folder will be populated with 1 xml for each object, sheet etc in your dashboard. I then use this to get metadata about my applicaation.

The following scriptm for example returns all expressions / charts back into a qlikview document

 

seT

SubDirectory

=...Master-prj\;

For

each

File

in

filelist

( SubDirectory

& '*CH*.XML')

EXPRESSIONDATA:
Load


%Key_Data_7EB7522AE0A7D03B

as

ExpressionID

,
[ExpressionVisual/Label/v]

as

ExpressionName

,
[ExpressionData/Definition/v]

as

ExpressionCalc

,
[ExpressionVisual/Label/v]

&': ' &[ExpressionData/Definition/v]

as

Expression

,
REPLACE

(REPLACE

('$(File)','$(SubDirectory)',''),'.xml','') as

ObjectID


FROM

[$(File)] (XmlSimple

, Table

is

[GraphProperties/Expressions/ArrayOfMainExpressionData/MainExpressionData/Data]);

CHARTDATA:
Load

[ChartProperties/Title/Title/v]

as

ChartTitle

,
[Dimensions/ChartDimensionDataDef/PseudoDef/Name]

as

DimensionCalc

,
[TableProperties/ExpansionInfo/ExpansionData/Pos/DimName]

as

DimensionName

,
REPLACE

(REPLACE

('$(File)','$(SubDirectory)',''),'.xml','') as

ObjectID


FROM

[$(File)] (XmlSimple

, Table

is

[GraphProperties]);

next




left

join

(CHARTDATA) load

ObjectID

,replace

(ObjectID

, 'CH','') as

CHTID

, concat

(distinct

DimensionCalc

) as

DimensionsConcat

REsident

CHARTDATA group

by

ObjectID

;

left

join

(EXPRESSIONDATA) load

ObjectID

,
concat

(distinct

Expression

,'
' )
as

ExpressionsConcat


REsident

EXPRESSIONDATA group

by

ObjectID

;

Not applicable

Re: how to export expressions from all reports into excel ?

thanks @Erica Whalley it really worked .

ashwanin
Valued Contributor

Re: how to export expressions from all reports into excel ?

Hi Snehal,

If you just need to export all the expressions used in Application then follow below path

Setting --> Expression Overview-->Select your required expressions ( i.e Chart Expression,Attributes,colour, show conditions,other expressions ) select all for whole-->click on Export --> Save file.

Community Browser