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
;
.
