how to show a staright table expression in a list box

[#1]

Hi all,

I have a straight table with 4 expressions and 3 dimensions and one of the expression (variance) having positive and negative values ,

my requirements is I need to create a list box as filter its should show 'positive' n 'negative' if user selects negative, only negative values should display in straight table and vice versa..

Thanks in advance

santhosh

[avinashelite]

Hi Venkat,

Please find the attachment for the solution.

[israrkhan]

you can do it, without list box...

go to your straight table properties>> presentation>> and select you expression and check searchable,

remember, the searchable option is available only for expressions, for dimension it is not available, but dropdownselect is available for dimension...see the image

and now you go to your table, you will see small icon for search, in your column...click it, you will see search box,

clear search box and type < 0 press enter, you will see only value are less than zero..for type > 0 for positive values..

see the image

hope it helps....

[#4]

Hi Israrkhan,

thanks for your quick reply and its is helpful, but I need to control negative values and positive values with list box .. do you have any idea..?

[#5]

Hi can you please send the attachment as I didn't get the attachment.

[israrkhan]

I Think you try like....

Create a Inline table,

Table:

Load * INLINE [

ValueType

Positive

Negative

];

Than create a list box for this ValueType..now you will have two value is list boxas

Positive

Negative

and go to table expressions modify your expressions like

if(GetFieldSelection(ValueType) = 'Positive', if( VarianceColumn > 0, VarianceColumn , null)  , if(GetFieldSelection(ValueType) = 'Negative', if(VarianceColumn  < 0, VarianceColumn , null )))

and select suppress null values..

try some thing like...

it might help

or share the document, i will try to help...

[Anonymous]

Hi Venkat,

pliz look at the image i have generated i have tested on the data u gave and seemed to work

the thing i did was to create an additional calculated field to the chart

let me know if it answers your question

[#8]

Hi please send me the attachment.

and do the needful

[Anonymous]

hi Ram  i have attached the file

look at the file attached

[#10]

Hi Avinash,,

Thanks for you test file

its helpful but my scenario is I have a straight table with 5 dimensions and four expressions ,

one of the expression is giving all the positive and negative values,

now can filter those positive or negative values by using a list box...?

Venkat.