12 Replies Latest reply: Mar 29, 2016 3:38 AM by rgv rand RSS

    sum problem

    sagar rahul

      hii

      i have two column in below tableie icdcode_alha and icdcode_num .

      i want do sum on this and if there sum goes beyond >0.7 then its an 'outlier' if not then its 'not outlier'

      (i want to use if condition and inline function)

       


      Icdcode_alpha

      Icdcode_num

      T

      2.9

      T

      2.8

      T

      2.7

      T

      2.6

      T

      2.5

      T

      2.4

      T

      2.3

      S

      43.3

      S

      43.2

      S

      43.1

      S

      43

      S

      42.9

      S

      42.8

      S

      42.7

      S

      42.4

      S

      42.3

      S

      42.2

      S

      42.1


      help me in dis as i m new on qlikview .