AGGR

[#1]

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.

[MK_QSL]

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

[swuehl · Accepted solution]

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

    Avg({<Month =   >}

                  aggr(

                      sum ( {<Month =   >} indicator )

                     ,Tech_Center,Region

                       )

          )

[#4]

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

[CELAMBARASAN]

Try with this

Avg({<Month =   >}

                  aggr(

                      sum ( {<Month =   >} indicator )

                     ,Tech_Center,Region

                       )

)