topic Expression? in QlikView

Expression?

Fri, 20 Nov 2020 18:02:30 GMT

Hi!

I've got a Straight Table that looks something like this;

Customer	Invoiced value	Andel fakturerat	TB	TB Andel	TB%
Total	3 000 000	15%	500 000		16,6%
A	1 000 000	5%	200 000	15%	5%
B	1 000 000	5%	200 000		5%
C	500 000	2,5%	50 000		3,3%
D	500 000	2,5%	50 000		3,3%

and what I want to do, is to divide the total Invoiced value with TB for each row. For example;

3 000 000/200 000 = TB Andel (=15) for Customer A.

Is it possible to do this in an Expression?

I hope you understand the weird explanation! Thank you!

srchilukoori — Tue, 08 Apr 2014 13:42:39 GMT

you can use

=column(1)/column(3)

as the expression for column(4), i.e., TD Andel

Anonymous — Tue, 08 Apr 2014 13:46:11 GMT

try this

=sum(TB)/sum(total Invoiced value)

its_anandrjs — Tue, 08 Apr 2014 13:49:29 GMT

You can write

=Sum( ALL [Invoiced Value]) / Sum(TB)

for each row in the table

cfz — Tue, 08 Apr 2014 13:51:41 GMT

Hi Jonathan,

Try

sum(TB)/(sum(TOTAL [Invoiced value])

This should solve the problem.

Regards

Carlos

its_anandrjs — Tue, 08 Apr 2014 14:03:14 GMT

You can also write it different ways also for TB Andel like

=(sum(ALL [Invoiced value]) / sum(TB)) & '%'

Thu, 19 Jan 2017 07:45:15 GMT

sum(ALL [Invoiced value]) / sum(TB)