1 Reply Latest reply: Nov 14, 2014 6:52 AM by Gysbert Wassenaar RSS

    output of the expression differs after drilling down the hierarchy

      Hi All,

       

      I am using Qlikview 11.2 version.

       

      I have straight table , in which i have 2 dimensions and an expression.

       

      The Dimensions used are, Department and team.

       

      expression used is :

      if(Not IsNull(Department),

             Num (

                   RangeSum (                

      if([sale] >= 1, Count ({$<[sale] = {'>=1'}>} DISTINCT period),0)

                     /

      (NoOfworkingDays_in_month)                   

                   )

             , '#.##0,00%'),

             (

            

             Num (

      RangeSum (if(IsNull(sale),0,

                                             Avg (

                                                             Aggr (   

      Count ({$<[sale] = {'>=1'}>} DISTINCT Period)

                                                                             /

      (NoOfworkingDays_in_month)

      ,  cod_dept, year)

                                             )             

      ))

             , '#.##0,00%')

             )

      )

      The standard table structure is as shown below:(Department A has been selected),

       

      DepartmentTeamExpression
      A120
      A230
      A340

       

      But when i select the filters Department: A nad Team:1  the following will be displayed:

       

      DepartmentTeamExpression
      A110

      Ideally the value should remain 20.

       

      this seems to be so weird.

       

      Can some one please let me know Why does the value of the expression change?what is the culprit?

       

      I have no triggers applied on this sheet.

       

      Thanks,