Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm using qlik sense desktop.
In my script I have 3 sections:
Section 1 : Projects
[Project]:
load
"project code",
'value",
FROM [lib://Fsbox/Financial data\Projects.xlsx]
(ooxml, embedded labels, header is 6 lines, table is [Projects]);
Section 2: Owners
[Owners]:
load
"project code",
"project owners"
FROM [lib://Fsbox/Financial data\Project owners.xlsx]
(ooxml, embedded labels, header is 6 lines, table is [Projects]);
In section 3 I want to load a new table that shows only projects with a value greater than 1000 with fields loaded in section 1 and 2. How should I whrite this script?
Section 3: Report
[FINAL]:
laod
if("value">1000,
"project code",
"value",
"project owners"
from ?!?!?!
Thank you,
FC.
Looks like you need a Resident load :
Is there any example that you can send me in qvf format?
Maybe {hopefully?} something like this. I have typing it freehand and as untested quite likely to have some typo's:
[Project]:
load
"project code",
'value"
FROM [lib://Fsbox/Financial data\Projects.xlsx]
(ooxml, embedded labels, header is 6 lines, table is [Projects]);
[MapOwners]:
mapping
load
"project code",
"project owners"
FROM [lib://Fsbox/Financial data\Project owners.xlsx]
(ooxml, embedded labels, header is 6 lines, table is [Projects]);
[FINAL]:
load
"project code",
applymap('MapOwners' , [project code]) as [Project Code] ,
"value"
resident [Project]
where [value] >1000 ;
drop table Project ;
If you have not come across Mapping Load / ApplyMap() before then check them in the Online Help