topic Re: list box filtered in QlikView

list box filtered

selcukcadir — Fri, 09 Nov 2012 09:24:39 GMT

hi all,

my table,

value1 valeu2

a xx

a yy

a zz

b tt

b ff

c kk

c rr

my list box

I want to appear in

only value <a>

value2

How do I make it ?

All currently is ;

value2

Re: list box filtered

Fri, 09 Nov 2012 09:32:36 GMT

so your value2 contains the ff:

and you want your value2 only contain this:

Is my understanding correct?

I don't know if there are simplier ways to do this, this is how you can do it with an if condition. when you create a list box on the 'field' value,

select expression. write an if statement what you want to filter.

if(value2='xx' or value2='yy' or value2='zz', value2)

Re: list box filtered

jagannalla — Fri, 09 Nov 2012 09:33:57 GMT

Hello,

Right click on sheet -> New Sheet Object -> List Box -> Click drop down box of Field Section -> You will find <Expression> -> Click on it

In expresson paste this code =If(value1 ='a', value2)

Hope it helps you

Cheers!!

Jagan Nalla

Re: list box filtered

jagan — Fri, 09 Nov 2012 10:16:06 GMT

Hi,

Try this script

Temp:

LOAD * INLINE [

value1,valeu2

a,xx

a,yy

a,zz

b,tt

b,ff

c,kk

c,rr];

Test:

LOAD

value1,

valeu2 as valueA

Resident Temp

WHERE value1='a';

Now provide valueA as Listbox. If you expression as Listbox it calculates everybox when selection changes. So this is good practice.

Regards,

Jagan.