Alternate State

[manoranjan_d]

Hi all,

In my UI i have two filters and one straight table

These two filters are defined with state

Filter 1 (field name : week end ) as state 1

and filter  2 (field name : week end ) as state 2

in the straight all the expression as defined with the two state

example

exp1:

=Only({[State1]}base_details)

exp2:

=Only({[State2]}base_details)

so the user can make week wise compare

Now third filter needs to be added

example : description field as filter3

suppose if the user select the filter 3(description filed) the data in the straight table wont change as per the filter3 selection bcoz we have declared the exp as state1 and state2, now how  to show the straight table  data with slection of  filter1,filter2 and filter 3.

[arvind_patil]

HI Manoranjan,

yes it cant work because description field will be common for all if you use filter 3 as week day  then it work . Other wise try to in separate table it will work .

Thanks,

Arvind Patil

[Kushal_Chawda]

=Only({[State1] <Filter1 = $::Filter1, Filter2 =$::Filter2 > }base_details)

like wise you can do for other state

Update : As sunny highlighted, added '=' sign

[sunny_talwar]

Don't you need an equal sign between Filter and $::Filter? Or does it work without equal also?

[Kushal_Chawda]

Yes we need . that' s the typo