0 Replies Latest reply: Sep 17, 2013 8:18 PM by Paul Yeo RSS

    How to implement HIC recent Blog post Counter in load ?

      Hi All

       

       

      After reading the below blog post from HIC .

       

       

      Counter in Load

       

       

      http://community.qlik.com/blogs/qlikviewdesignblog

       

       

      I just create a simple QV doc , already plot the line by YearMonth.

       

       

      But not sure how to add below code into my script.

       

       

      Load *,

         If(  Change * Peek( Change ) > 0,

              Peek( TrendID ),

              RangeSum( 1, Peek( TrendID ))

              ) as TrendID,

         If(  Change * Peek( Change ) > 0,

              RangeSum( 1, Peek( DaysWithTrend )),

              0

              ) as DaysWithTrend;

      Load

         Indicator,

         Indicator - Peek( Indicator ) as Change

      Resident Daily_TQM_Measurement

         Order By Date;

        

      Hope some one understand the script well can share with me.

       

       

      Paul