Filter Pane: Get Field Selection Error

[Purushothaman]

Hi there,

I am facing following error in this script, what's wrong here. Anyone, Please help!! 

I am using  a filter pane and script is: 

Thank you!!

[Or]

Your if() statements have more than three parameters, seemingly. Did you perhaps mistakenly use a comma instead of an AND?

[Purushothaman]

Hi @Or ,

Thank for the prompt reply, I did need this selection of fields in a filter based on a another filter selection:

Below is illustration:

[Or]

Sorry, but that doesn't really clear anything up for me. Each product has multiple outgoing arrows with no indication of how you're supposed to decide between them?

Currently, your if() statements have too many sections. The syntax should be:

If(Condition,Then,Else)

or of course

If(Condition1 AND Condition2,Then,Else)

Generally speaking populating a filter with an if() statement at the front-end level isn't the best policy, it's usually better to create the underlying values in script, e.g.

Load * INLINE [

Product, Price Segment

TV, Preset

TV, By $100

REF, By $100
REF, By $200

WM, By $100

WM, By $200

];

[Mark_Little]

Hi there, 

Could you please clear up where you are writing the script/expression.

Although the syntax is correct, i believe the way you are trying to set the second field value you is incorrect. 

Set Analysis is used to return a value from the data not select a value in a field.