topic Re: pivot_expression in QlikView

pivot_expression

Tue, 30 Apr 2013 07:59:05 GMT

Dear all

Seek your expertise. I have a pivot table as below:

Direction	No of Account	Approved Limit (RM'm)	=Aggr(Sum(TMLimit),TM)/ Sum({$<TM-={9700}>} TMLimit)
Non Target	12	477	0.029837476
Selective	42	2,382	0.043216205
Target	8	509	0.038476882

I failed to get the desired result for last column as below

14%

71%

15%

rgrds

Re: pivot_expression

narender123 — Tue, 30 Apr 2013 08:07:03 GMT

Hi,

There is no TM column in your pivot table .1st you have to add TM for aggregation. if you want the result in % then you have to check "Relative" check box(in property of pivot table) also check % in number field of property of pivot chart..after this you can get the result in %.

Thanks.

Regards:

Narender

Re: pivot_expression

Tue, 30 Apr 2013 09:37:56 GMT

1. Direction is the calculated TM dimension:

= if(SCC <> 9700, TM)

2. the result is not accurate even i convert them to %

Re: pivot_expression

amars — Tue, 30 Apr 2013 09:46:31 GMT

Hi Alex,

Try out this one for %

Aggr(Sum(TMLimit),TM) / Sum(Total Aggr(Sum(TMLimit),TM))

and convert it into % in the Numbers tab.

Thanks