Filter from an expression in a chart

[#1]

I have an expression called Passing in a straight table chart. The expression is:

Maxstring({<[Field1]={1},[Field2]={2},[Date1]={">=$(v_Period1) <=$(v_Period2)"},[Field3]={'YES'}>} [Field4})

Field4 always equals yes. Therefore, if the above set analysis conditions are met, Yes or Null are returned. Null Symbol under presentation is set as No.

This expression needs to be dynamic because v_Period1 and v_Period2 are variables calculated from Min and Max statements that need to change when filtering by department for example.

Our users want to be able to filter the Passing coulmn in the straight table chart to see either No or Yes. I have tried several different things (including an expression in a list box) but cannot make this work.

Does anyone have any suggestions?

Thanks in advance,

Drew Collins

[buzzy996]

may be, create variable and list all ur fields in list box of that variable.

and pass that variable as parameter to ur field.

[sunny_talwar]

Not completely sure if I understand your requirement, would you be able to share a sample?

Best,

Sunny

[Anonymous]

I noticed that you have a curly bracket in Field4, if that's the actual formula you are using change it to ]

[Field4})

[Anonymous]

Did you try "Searchable" checkbox?

[stigchel]

A listbox with expression

=If(Field4='Yes','Yes','No')

Or am I missing something?

[#7]

That was actually a typo while I was posting.

[#8]

Piet, Field4 always equals Yes.

[#9]

Sunny, I cannot share an example as this contains highly sensitive information.

[stigchel]

Yes I know, have you tried?