need help

[#1]

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.

[prieper]

what is not correct?

[prieper]

EXISTS() refers only to existing values.

So the second table cannot be loaded, if there are no data previously loaded for Client

[bobdawes]

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.

[#5]

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?

[bobdawes]

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);