Set analysis accessing alternate states

Wed, 15 May 2013 11:19:10 GMT

Hi everyone,

I have a complex set analysis expression and i am trying to access a specific alternate state on it. My expression is as follows:

(Count({<BoundariesKey={'NV200-X2 UV Reflected 200-OverallGain'},SensorValue={"= SensorValue>= HighControlLimit"} + {"= SensorValue<= LowControlLimit"}>}SensorValue) /

sum({<BoundariesKey={'NV200-X2 UV Reflected 200-OverallGain'}>}RowCounter))>=0.5

I tried the above but did not seem to work:

(Count({[AlternateState1]<BoundariesKey={'NV200-X2 UV Reflected 200-OverallGain'},SensorValue={"= SensorValue>= HighControlLimit"} + {"= SensorValue<= LowControlLimit"}>}SensorValue) /

sum({[AlternateState1]<BoundariesKey={'NV200-X2 UV Reflected 200-OverallGain'}>}RowCounter))>=0.5

Any other proposed solutions anyone???

Regards

topic Set analysis accessing alternate states in QlikView

Set analysis accessing alternate states