topic Count run of negative values in QlikView

Count run of negative values

Tue, 14 Jun 2016 11:06:01 GMT

Hi,

I have a dataset with positive and negative values. Within the dataset there is a unique identifier that start at '1' and increments by 1 for each row. Is it possible to count the maximum occurrence of a run of negative values eg,

so using the above example I would like to show '5' in a text box the the largest consecutive run of negative values is 5..

Is this possible?

Many thanks

Re: Count run of negative values

swuehl — Tue, 14 Jun 2016 11:36:40 GMT

You can maybe do it like shown here

Counters in the Load

add a preceding load:

LOAD *,

If(Sign(Indicator) =1, DaysWithTrend,0) as DaysWithPositiveTrend,

If(Sign(Indicator) =-1, DaysWithTrend,0) as DaysWithNegativeTrend

;

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;

Then in your text box:

=Max( DaysWithNegativeTrend)

Re: Count run of negative values

trdandamudi — Tue, 14 Jun 2016 11:42:48 GMT

May be as attached: