topic Re: Precending load in QlikView

Precending load

Mon, 20 Oct 2014 14:48:38 GMT

here's my problem, i have two excel files, every file has a lot of fields for example,

first file,

file 1;

load

FROM file1;

second file

FROM FILE 2

what i want to do is:

take the field B and the field M and make the sum.

that's all.

thank's for help

Re: Precending load

ashfaq_haseeb — Mon, 20 Oct 2014 16:16:09 GMT

Hi,

Try like this in a text box

=sum(B)+sum(M)

Regards

ASHFAQ

Re: Precending load

JonnyPoole — Mon, 20 Oct 2014 16:19:02 GMT

Is the data related ? For example, are all the fields the same (ie: A=x , B=H, C=J etc...) ?

Re: Precending load

anbu1984 — Mon, 20 Oct 2014 16:30:10 GMT

What is the join key for two files?

Re: Precending load

Tue, 21 Oct 2014 08:16:03 GMT

no, the fields are not the same , and when i do sum(B)+sum(M) i've got an error.

Re: Precending load

Tue, 21 Oct 2014 08:16:52 GMT

there's no join key.

Re: Precending load

ashfaq_haseeb — Tue, 21 Oct 2014 08:18:10 GMT

Hi,

Did you try my solution?

If possible share sample data.

Regards

ASHFAQ

Re: Precending load

Tue, 21 Oct 2014 08:20:16 GMT

yes i did but i've got an error

Re: Precending load

Tue, 21 Oct 2014 08:20:48 GMT

where i should write sum(B)+sum(A)??

Re: Precending load

ashfaq_haseeb — Tue, 21 Oct 2014 08:24:00 GMT

Create new text object and write below code.

=sum(B)+sum(M)

Modify your fields accordingly.

Regards

ASHFAQ

Re: Precending load

Tue, 21 Oct 2014 08:28:05 GMT

No, what i want to do is to create a new column in the script

for exemple:

sum(B)+sum(M) as la_somme

but what you should to know is, B and M are in different files, this is the problem.

Re: Precending load

kuba_michalik — Tue, 21 Oct 2014 08:30:13 GMT

What do you want to do exactly? Sum all values in B together with all values in M, but in the script? First, it's way easier in the frontend, as Ashfaq Mohammed pointed out. Second, if you really need to do it in the script, then one way is this:

Temp1:

LOAD

Sum(B) as SumB

Resident NameOfTableWith_B_Column;

Temp2:

LOAD

Sum(M) as SumM

Resident NameOfTableWith_M_Column;

LET vSumOfBandM = Peek('SumB')+Peek('SumM');

DROP TABLES Temp1, Temp2;

Now you have the sum in variable vSumOfBandM and can do with it whatever you need to do.

Again, if you don't absolutely need this sum in the script for some calculations or something, then don't do it in the script. Calculate it directly in the frontend.

Re: Precending load

Tue, 21 Oct 2014 08:58:46 GMT

thnx it works.

Re: Precending load

kuba_michalik — Tue, 21 Oct 2014 09:02:26 GMT

Please mark it as a correct answer then (not to be asking for accolades, but it marks the question as answered which helps for other people viewing the forum)