Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set analysis accessing alternate states

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

Community Browser