If-Else statement need to used in list box while using direct query at script level

[neetu_singh]

Dear All,

Am using "direct query" at script level for a single table.

The problem is if am using "if-else" in a listbox at GUI, its not working.

My requirement is like - I have one island table having single column as Period & values for this column is - CST/IST/PST.

& have three column in direct query as dimension i.e. TIME_CST, TIME_IST, TIME_PST.

Now what i need is in a single list box if am selecting CST, then the values should be come for TIME_CST ND if am selecting IST then in that same list box value should come for TIME_IST.

Need help on urgent basis.

Thanks in Advance.

[saurabh5]

I think calculated dimensions  won't be possible using direct query.