Sum all value

[realpixel]

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

[swuehl]

Have you tried

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

as expression?

[narender123]

Hi ,

I have attached the file.please find it.

Thanks.

[calvindk]

Sum(EPV) / SUM(TOTAL EPV)

[realpixel]

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

[#6]

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

[swuehl · Accepted solution]

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