topic Re: relaitive in pivot in QlikView

relaitive in pivot

Anonymous — Thu, 23 Jan 2014 12:40:13 GMT

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:

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

thanks'

yarin.

Re: relaitive in pivot

hic — Thu, 23 Jan 2014 12:52:32 GMT

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

Re: relaitive in pivot

Clever_Anjos — Thu, 23 Jan 2014 12:54:25 GMT

Sum(value) / sum(Total value)

If you need aggr by some dimension

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

Re: relaitive in pivot

Anonymous — Thu, 23 Jan 2014 13:03:01 GMT

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

Re: relaitive in pivot

Clever_Anjos — Thu, 23 Jan 2014 13:07:42 GMT

( 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])

Re: relaitive in pivot

Anonymous — Thu, 23 Jan 2014 13:29:39 GMT

hi,

i get nathing, what can be the problem ?

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

Re: relaitive in pivot

Clever_Anjos — Thu, 23 Jan 2014 13:34:15 GMT

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]) )