Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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

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;

1 Reply
Not applicable

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

Also note that I don't have the original source files the qlikview file was loaded with. That is the major reason for this question