topic Set Analysis Condtional in QlikView

Set Analysis Condtional

Thu, 03 Dec 2015 15:40:45 GMT

I have the following formula:

=Avg({1<TubeType=P(TubeType)>}[Total Usage]) I need to add another condition that includes only data where Flag=0, does anyone have an ideas?

Thu, 03 Dec 2015 17:37:42 GMT

Hi Zeth, I think that a solution may be:

=Avg( {< TubeType={"TubeType"} , Flag={"0"} >} [Total Usage])

I hope that it help you

Regards

Agustín

Thu, 03 Dec 2015 17:42:49 GMT

The following is the solution that acutally worked, thanks for the idea though it helped me solved the issue!

=Avg({1<TubeType=P(TubeType),Flag={'0'}>}[Total Usage])