relaitive in pivot

[Anonymous]

hi,

i have pivot with 2 diemensions, and 1 exp.

i want to add new exp, that show the reilative part from the total - hope it's understood.

how can i do it ?

see exm:

		a	b
first-dim	second-dim
total		100
1	A	10	10%
2	B	20	20%
3	C	30	30%
4	D	40	40%
5	E

thanks'

yarin.

[hic]

If your expression is Sum(a) then the relative part can be calculated through Sum(a) / Sum(total a)

See more on http://community.qlik.com/blogs/qlikviewdesignblog/2013/09/09/aggregation-scope

HIC

[Clever_Anjos]

Sum(value) / sum(Total value)

If you need aggr by some dimension

Sum(value) / sum(Total <Dim1> value)

[Anonymous]

hi,

thanks' ...my exp. go like this :

sum({$<_Flag={Inv,InvAdel},PFLAG={3},[KG]={">0"}>}[ZIKUY])
+SUM({$<_Flag={Inv,InvAdel},PFLAG={3},[KG]={">0"}>}[ROW])
+SUM({$<_Flag={Inv,InvAdel},[KG]={">0"}>}[PRICE])

HOW DO I DO IT ???

THANKS' AGIAN

YARIN

[Clever_Anjos]

( sum({$<_Flag={Inv,InvAdel},PFLAG={3},[KG]={">0"}>}[ZIKUY])
+SUM({$<_Flag={Inv,InvAdel},PFLAG={3},[KG]={">0"}>}[ROW])
+SUM({$<_Flag={Inv,InvAdel},[KG]={">0"}>}[PRICE]) /

sum(total {$<_Flag={Inv,InvAdel},PFLAG={3},[KG]={">0"}>}[ZIKUY])
+SUM(total {$<_Flag={Inv,InvAdel},PFLAG={3},[KG]={">0"}>}[ROW])
+SUM(total {$<_Flag={Inv,InvAdel},[KG]={">0"}>}[PRICE])

[Anonymous]

hi,

i get nathing, what can be the problem ?

when i check calculte only the total rows it's o.k.

[Clever_Anjos · Accepted solution]

Sorry, i missed '(', this should work

( sum({$<_Flag={Inv,InvAdel},PFLAG={3},[KG]={">0"}>}[ZIKUY])
+SUM({$<_Flag={Inv,InvAdel},PFLAG={3},[KG]={">0"}>}[ROW])
+SUM({$<_Flag={Inv,InvAdel},[KG]={">0"}>}[PRICE]) ) /

( sum(total {$<_Flag={Inv,InvAdel},PFLAG={3},[KG]={">0"}>}[ZIKUY])
+SUM(total {$<_Flag={Inv,InvAdel},PFLAG={3},[KG]={">0"}>}[ROW])
+SUM(total {$<_Flag={Inv,InvAdel},[KG]={">0"}>}[PRICE]) )