1 Reply Latest reply: Feb 12, 2017 7:13 AM by Nkwocha Promise RSS

    Binary load a qlikview file to export only a loaded excel sheet without table name.

    Nkwocha Promise

      Please how do I get out just the [FP\Detailed FP\Mapplet\GroupDetailed.qvx] data from this script. I need to know what exactly the [FP\Detailed FP\Mapplet\GroupDetailed.qvx] fiile contains...thanks

       

      T:

      LOAD CompCode,

           Company,

           [Company Name],

           [FS Version - FS Version Level 01 (Text)] as [FS Version],

           [Financial statement item text],

           [Computed Balance],

           [Report Type],

           [Financial Statement Item No] as [Financial Statement Item],

           [Financial statement item text] as [Financial statment],

           Year  &' NGN' as YearNGN,

           Year,

           Month,

           Data

      FROM

      [FP\Detailed FP\QV4.qvd]

      (qvd)

      Where Year <= 2014 and Year >= 2013 and Month = 'December';

       

      NOConcatenate

      LOAD [Financial Statement Item],

           [Financial statement item text],

           Year,

           Company,

           Month,

           Year &' NGN'as YearNGN,

           CompCode

      FROM

      [FP\Detailed FP\Mapplet\GroupDetailed.qvx]

      (biff, embedded labels, table is [FP Detailed CON$])

      Where Year <= 2014 and Year >= 2013;