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

Sun, 12 Feb 2017 11:48:00 GMT

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

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;

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

Sun, 12 Feb 2017 12:13:52 GMT

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

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

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

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