topic Re: need help in QlikView

need help

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: need help

prieper — Thu, 18 May 2017 13:21:25 GMT

what is not correct?

Re: need help

prieper — Thu, 18 May 2017 13:22:54 GMT

EXISTS() refers only to existing values.

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

Re: need help

bobdawes — Thu, 18 May 2017 13:26:59 GMT

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.

Re: need help

Thu, 18 May 2017 13:39:56 GMT

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?

Re: need help

bobdawes — Thu, 18 May 2017 13:48:45 GMT

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