topic Re: Please help me with the below expression. in QlikView

Please help me with the below expression.

Tue, 08 Oct 2013 11:32:34 GMT

I am trying to calculate the Growth Amt over the Goal amt to use as a percentage.

AGGR(SUM({$<[Metric Type]={'Actual'}>}[Deposit Growth Amt]),[Goal Employee Id]) / (AGGR(SUM({$<[Metric Type]={'Goal'}>}[Deposit Growth Amt]),[Goal Employee Id]))

Re: Please help me with the below expression.

qlikpahadi07 — Tue, 08 Oct 2013 11:37:53 GMT

attach a Sample which will be helpful

Re: Please help me with the below expression.

Tue, 08 Oct 2013 11:38:43 GMT

Hi Aptha,

As per your requirement Im trying to understand why are you using aggr()? aggr() calculates cummulatively.

Is that what you want?

I believe you could write something like this:

num(sum({<[Metric Type]={'Actual'}>}[Deposit Growth Amt]) / sum({<[Metric Type]={'Goal'}>}[Deposit Growth Amt]),'##.##')

the num() here is optional.

as there is a check box that says "Show Relative".Please keep this Checked .

Hope this helps.

Please get back to me with the result.

Rochelle

Re: Please help me with the below expression.

israrkhan — Tue, 08 Oct 2013 11:42:23 GMT

HI,

What are your dimensions in Table,

Re: Please help me with the below expression.

Tue, 08 Oct 2013 13:22:03 GMT

Thank you John.It did work.

Re: Please help me with the below expression.

Tue, 08 Oct 2013 13:47:55 GMT

Im glad I could help