5 Replies Latest reply: Feb 14, 2014 2:57 AM by Ashwani Kumar RSS

    how to export expressions from all reports into excel ?

    snehal mejari

      ..

        • 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 ?

            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

            ;

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

              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.