CODEWITHSUNDEEP
spotfire
Bharath Abhishek
Bharath Abhishek

Reputation: 69

Cascaded Filter in spotfire

I am using cascaded filters in my reports and I have my expression like below -

if ([Region] = "${whichRegion}",[State],null)

along with the above expression, I would like to preselect one of the values of [state] column.

i would need some thing like this -

if ([Region] = "${whichRegion}",[State],null)

or

[State] = 'some default value'

I know above expression throws error.

Could you please let me know how the above expression can be modified ?

Upvotes: 1

Views: 696

Answers (1)

S3S
S3S

Reputation: 25112

Just place your default state value in your false clause.

if([Region] = "${whichRegion}",[State],"DefaultStateValue")

BTW, where are you using this expression at?

Upvotes: 1

Related Questions