topic divide with 2 collumms/tables in 1 in QlikView

divide with 2 collumms/tables in 1

Thu, 18 Sep 2014 09:27:38 GMT

Hi guys,

can you tell me how can I divide with 2 tables ?

example:

Tab1:

Load DocNo,

ArtNo,

Cost, // here are amounts that costs with discount like: 550€ & -50€

Quantity, //here are all quantity like 25 and 25

FROM ..

Now I want to sum(cost)/sum(quantity).

Is it possible to use it in script?

Backend in expressions, it works.

MayilVahanan — Thu, 18 Sep 2014 09:31:17 GMT

Try like this

Load DocNo, ArtNo, Cost, Quantity, Cost/Quantity As Percentage From ... ;

anbu1984 — Thu, 18 Sep 2014 09:32:39 GMT

You have to use group by

Load DocNo,

ArtNo,

sum(cost)/sum(quantity)

FROM ..

Group by //Include all columns other than cost and quantity

DocNo,ArtNo

MK_QSL — Thu, 18 Sep 2014 09:33:36 GMT

You can do as below

Tab1:

Load DocNo,

ArtNo,

Cost,

Quantity,

Cost/Quantity as YourNewFieldName

FROM ..

Tab2:

Load

DocNo,

ArtNo,

SUM(Cost)/SUM(Quantity) as YourNewFieldName

Resident Tab1

Group By DocNo, ArtNo...

But the 1st Method is more efficient...