Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have calculated sum and average for the corresponding process
I received another table having sub process field with partial sums.
not getting accurate results after I loaded second table into qlikview.
I have tried with join,concatenate but not working.
how to combine both tables to calculate at this situation
PFB of sample data.
Please help me on this.
what is not correct?
EXISTS() refers only to existing values.
So the second table cannot be loaded, if there are no data previously loaded for Client
Your second table seems to essentially be "line level" data for sub processes, whereas the first table is "header" data for processes.
After you fixe the EXISTS clause that Peter accurately noted, suggestion is to put value1 from the line level into a different field, which you can then compare to value 1 form the header records. Ultimately, assuming they always match, you won't need to load the header value 1.
I have already tried with exists but not getting...
I want to load sub process and sum for the particular client.
how it can be possible?
Can you try with my sample data?
The exists is your problem.
I'd load these tables along these lines:
Process:
LOAD process,
MonthYr,
process & '|' & MonthYr as %ProcessMonthKey,
value1,
value2,
value3
FROM
(ooxml, embedded labels, table is Sheet1);
SubProcess:
NoConcatenate
LOAD
process & '|' & MonthYr as %ProcessMonthKey,
//process,
[Sub Process],
// MonthYr,
value1 as SubProcessValue1,
value2 as SubProcessValue2,
value3 as SubProcessValue3
FROM
(ooxml, embedded labels, table is Sheet2);