Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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