topic Re: Expression in QlikView

Expression

NavinReddy — Thu, 03 Oct 2013 10:14:53 GMT

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

Re: Expression

tresB — Thu, 03 Oct 2013 10:32:33 GMT

May be like sample attached ?

Re: Expression

Thu, 03 Oct 2013 10:36:27 GMT

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

Re: Expression

NavinReddy — Thu, 03 Oct 2013 10:48:15 GMT

Yes

Re: Expression

NavinReddy — Thu, 03 Oct 2013 11:04:42 GMT

any idea

Re: Expression

tresB — Thu, 03 Oct 2013 11:08:00 GMT

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?

Re: Expression

NavinReddy — Thu, 03 Oct 2013 11:27:17 GMT

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

Re: Expression

tresB — Thu, 03 Oct 2013 11:49:26 GMT

Sorry, not yet clear to me.

Re: Expression

NavinReddy — Thu, 03 Oct 2013 12:26:45 GMT

thank you i did this creation two list boxes

i used show and hide condition working fine