topic Sum all value in QlikView

Sum all value

realpixel — Fri, 10 May 2013 11:47:24 GMT

Hello,

I create a dimenssion TRANS and an expression which can do the sum of EPV but I cannot arrive to do this operation sum EPV\total EPV

For example for A value I need to do (161\1428) x 100

For B value (15\1428) x 100

etc.

Someone have I idea how to do?

TRANS	EPV
A	161
B	15
C	53
D	17
E	2
F	22
G	28
H	15
I	23
J	11
K	59
L	170
M	275
N	59
O	118
P	6
Q	144
R	250
	1428

Re: Sum all value

swuehl — Fri, 10 May 2013 12:06:34 GMT

Have you tried

= Sum( EPV ) / Sum( Total EPV ) *100

as expression?

Re: Sum all value

narender123 — Fri, 10 May 2013 12:32:34 GMT

Hi ,

I have attached the file.please find it.

Thanks.

Re: Sum all value

calvindk — Fri, 10 May 2013 12:34:39 GMT

Sum(EPV) / SUM(TOTAL EPV)

Re: Sum all value

realpixel — Fri, 10 May 2013 13:54:22 GMT

Thank everybody for your answer, it's works but if I put a selection/filter in column TRANS to see only the value A the result is always 100, it's the same problem with other value.

Same problem on document "New Qlikview document" posted by Narender123

Column1	Sum
	100
A	100

If I use a seclection on column1 to see only the A value, the sum is 100 and not 20.

Column1	Sum
	100
A	20
B	40
C	20
D	20

Re: Sum all value

Fri, 10 May 2013 13:58:25 GMT

When you select A - formula is 20/20*100 = 100, so I think it`s correct.

EDIT: If you want to see select field/ sum all fields *100 then formula will be Sum(Column2)/ Sum({<Column1=>}Total Column2)*100 - (20/100)*100

Re: Sum all value

swuehl — Fri, 10 May 2013 13:59:11 GMT

I am not fully understanding your sample, but you can disregard your selections for the Total like this:

= Sum( EPV ) / Sum({1} Total EPV ) *100

or disregarding only selection in TRANS:

= Sum( EPV ) / Sum({<TRANS= >} Total EPV ) *100