4 Replies Latest reply: Oct 8, 2013 11:45 AM by Celambarasan Adhimulam RSS

    AGGR

      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
          Manish Kachhia

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

          • Re: AGGR
            Stefan Wühl

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

             

                Avg({<Month =   >}

                                 

                              aggr(

                                  sum ( {<Month =   >} indicator )

                                 ,Tech_Center,Region

                                   )

                      )

            • Re: AGGR

              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 Adhimulam

                Try with this

                Avg({<Month =   >}

                                  aggr(

                                      sum ( {<Month =   >} indicator )

                                     ,Tech_Center,Region

                                       )

                )