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
