How to implement HIC recent Blog post Counter in load ?

Mon, 26 Jan 2026 18:19:17 GMT

Hi All

After reading the below blog post from HIC .

Counter in Load

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 )),

) 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

topic How to implement HIC recent Blog post Counter in load ? in QlikView