topic Re: AGGR Statement in QlikView

AGGR Statement

tmumaw — Tue, 22 Apr 2014 17:38:22 GMT

Can someone help me convert this to an AGGR statement?

If(sum([Inv Gross]) >= $(vMax) and sum([Inv Gross]) <= $(vMax1) and

(sum([Billing Item Counter]) >= $(vMax2) and Sum([Billing Item Counter]) <= $(vMax3),

(sum([Inv Gross])))

My dimension would be Level1

Thanks

Re: AGGR Statement

preminqlik — Tue, 22 Apr 2014 17:42:49 GMT

hi there try this

sum(aggr(

If(sum([Inv Gross]) >= $(vMax) and sum([Inv Gross]) <= $(vMax1) and

(sum([Billing Item Counter]) >= $(vMax2) and Sum([Billing Item Counter]) <= $(vMax3),

(sum([Inv Gross])))

,Level1))

Re: AGGR Statement

its_anandrjs — Tue, 22 Apr 2014 17:46:59 GMT

Try Like this

=Aggr(If(sum([Inv Gross]) >= $(vMax) and sum([Inv Gross]) <= $(vMax1) and sum([Billing Item Counter]) >= $(vMax2) and Sum([Billing Item Counter]) <= $(vMax3),(sum([Inv Gross]))), Level1)

=Sum(Aggr(If(sum([Inv Gross]) >= $(vMax) and sum([Inv Gross]) <= $(vMax1) and sum([Billing Item Counter]) >= $(vMax2) and Sum([Billing Item Counter]) <= $(vMax3),(sum([Inv Gross]))), Level1))

Re: AGGR Statement

tmumaw — Tue, 22 Apr 2014 17:49:41 GMT

Nope

Re: AGGR Statement

tmumaw — Tue, 22 Apr 2014 17:49:48 GMT

Nope

Re: AGGR Statement

its_anandrjs — Tue, 22 Apr 2014 17:57:13 GMT

May be Try this

=Aggr(sum(If(sum([Inv Gross]) >= $(vMax) and sum([Inv Gross]) <= $(vMax1) and sum([Billing Item Counter]) >= $(vMax2) and Sum([Billing Item Counter]) <= $(vMax3), [Inv Gross]),Level1)

Re: AGGR Statement

lironbaram — Tue, 22 Apr 2014 18:53:48 GMT

what are you looking to achieve using aggr function

those the result of the expression should be display in a single line

Re: AGGR Statement

bgerchikov — Tue, 22 Apr 2014 19:02:52 GMT

Hi Thom,

I'd suggest to use the following as Calculated Dimension:

=Aggr(If(sum([Inv Gross]) >= $(vMax) and sum([Inv Gross]) <= $(vMax1) and sum([Billing Item Counter]) >= $(vMax2) and Sum([Billing Item Counter]) <= $(vMax3),(sum([Inv Gross]))), Level1)

Expression:

sum([Inv Gross])

Hope it'll help

Re: AGGR Statement

tmumaw — Tue, 22 Apr 2014 19:20:15 GMT

Boris,

It's close, but no Level1 dimension is displayed.

Thanks

Thom

P.S. I made the dimension an expression.

Re: AGGR Statement

bgerchikov — Tue, 22 Apr 2014 21:58:42 GMT

Thom,

It would be easier to help you out if you'd attach some example. Are you sure you have Level1 records that satisfied these conditions i the current selection? Also, please double-check syntax.

Thanks!