topic Re: AGGR in QlikView

AGGR

Tue, 08 Oct 2013 15:30:33 GMT

Hi

I'm new in qlikview development and i want to use aggr function with set analysis. I have a problem when i use the following expression in my report because the "Month = " is ignore. Can i have more details about posibilities with aggr function and some advice in my scripting.

Avg(

aggr(

sum ( {<Month = >} indicator )

,Tech_Center,Region

)

)

Lionel T.

Re: AGGR

MK_QSL — Tue, 08 Oct 2013 15:42:03 GMT

Dear.... let us know your requirements or something about data and fields....

Re: AGGR

swuehl — Tue, 08 Oct 2013 15:42:55 GMT

You may need to add the set expression also to the outer aggregation:

Avg({<Month = >}

aggr(

sum ( {<Month = >} indicator )

,Tech_Center,Region

)

)

Re: AGGR

Tue, 08 Oct 2013 15:44:52 GMT

Hello,

As you stated qlikview dont pay attention to the month selection... is not what you want? ´casue the expression is alright at best of my knowledge.

regards

Re: AGGR

CELAMBARASAN — Tue, 08 Oct 2013 15:45:22 GMT

Try with this

Avg({<Month = >}

aggr(

sum ( {<Month = >} indicator )

,Tech_Center,Region

)

)