4 Replies Latest reply: May 9, 2013 8:00 AM by Gysbert Wassenaar RSS

    Median of count

      HI,

       

      I am new to Qlikview, and would like to obtain the median of a count distribution.

       

      I have the following IDs.

      ID
      1
      2
      3
      1
      2
      3
      4
      5
      6
      7
      8
      9
      10
      3
      1
      2
      8
      9
      10

       

      I would like to find the median, in this case, after sorting and adding, would be:

      IDcount(ID)
      41
      51
      61
      71
      82
      92
      102
      13
      23
      33

       

      the median of count(ID) is 2.  

       

      How should the expression be?

       

      thanks!