4 Replies Latest reply: Nov 17, 2017 12:34 AM by Ming Jiun Wong RSS

    Aggr and Median Function

    Ming Jiun Wong

      Dear all,

       

      I have no idea how the aggr and median function works in QlikView. I have the data below.

      FACT_PA_NOFiscal YearDivisionTotalCashFiscalNumYearFiscalMonth
      7141FY13/14Motors709.520131
      7141FY13/14Motors72020132
      7141FY13/14Motors103220135
      7141FY13/14Motors103920133
      7141FY13/14Motors104520138
      7141FY13/14Motors1046.520137
      7141FY13/14Motors104720134
      7141FY13/14Motors1067.520136
      7141FY13/14Motors1074.520139
      7141FY13/14Plantation1111.5201310

       

      When I create a chart using the median and aggr function, Qlikview will show me the not consistent result which means the somehow expression result will assign to different Division after reload every time.

      Capture.JPG  Capture1.JPG

       

      Can anyone tell me how the QlikView actually work with the aggr function? Besides, if I wanted to force the expression result according to the Max FiscalMonth, how can I do it? The attachment is my test application.