Expression

[NavinReddy]

Hi All,

i have one list box

which has some values how can i filter values like condition wise

and list box im getting two sides how to restrick one side

if([Sub Line of Business Name]='Businessb Banking',Aggr(Only({<[Revenue Band ID]={'1','2','3','4','5'}>}Revenue_Band_Category),[Revenue Band ID]),

if([Sub Line of Business Name]='Commercial',aggr(only( {<[Revenue Band ID]={'6','7','8','9','10','11','12','13'}>}Revenue_Band_Category),Revenue_Band_Category)

These expression not working

plz find the attechment

Thanks In Avance

Niru

[tresesco]

May be like sample attached ?

[#3]

Hi Niru,

What do you want to do ? Filter values in the ListBox ?

if so,

1) create an Expression (instead of taking directly the field name). In the general tab, not in the Expression tab

2) Type your Expression, sth like : if (boolean condition, YourDIM)

For example, I just want the Customer starting with LEX I will do : if(mid(CUSTOMER, 1, 3)= 'LEX', CUSTOMER)

(or I could use LEFT but that is the same)

Your expression should therefore return the dimension you want to get in the ListBox.

Fabrice

[NavinReddy]

Yes

[NavinReddy]

any idea

[tresesco]

A bit confusing ! You wrote 'Yes'. What was that for? So you did not get what you wanted; can you please explain a bit more?

[NavinReddy]

that list box expression not working

one condition business banking i want to fetch 1-5 revenue band id

one condition commercial list box revenue band id should be 6-13

[tresesco]

Sorry, not yet clear to me.

[NavinReddy · Accepted solution]

thank you i did this creation two list boxes

i used show and hide condition  working fine