topic Re: Re: Listbox value filtration in QlikView

Listbox value filtration

muniyandi — Fri, 01 Aug 2014 10:23:31 GMT

Hi All,

I have TestCase1,TestCase2 , 2 column have same value . TestCase1 list box selected value, not include in the TestCase2 listed value. TestCase2 should filter the TestCase1 select value.

Kindly find the attachment file.

Re: Listbox value filtration

simenkg — Fri, 01 Aug 2014 10:27:20 GMT

Your tables are not connected.

Test_Case:

LOAD * INLINE [

TestCase1,TestCase2

AAA, AAA

BBB, BBB

CCC, CCC

DDD, DDD

EE, EE

F, F

GGG, GGG

];

Re: Re: Listbox value filtration

muniyandi — Fri, 01 Aug 2014 10:33:27 GMT

Hi Simen,

Thanks for reply,

I am using list box for enable disable condition purpose. you case filtered only matched values.

i expected result is not equal value.

Kindly refer my attached image file.

Thanks,

Muni

Re: Listbox value filtration

simenkg — Fri, 01 Aug 2014 10:53:56 GMT

In your second listbox do the following:

Select Expression as your field and enter the expression:

=Aggr(only({$<TestCase2=E(TestCase1)>}TestCase2),TestCase1)

Re: Re: Listbox value filtration

muniyandi — Fri, 01 Aug 2014 10:57:52 GMT

Hi Simen, i tried your expression in the listbox ,it's not working ,

can you post , QVW file.

Re: Listbox value filtration

Fri, 01 Aug 2014 11:01:05 GMT

Try like this

=Aggr(only({<Testcase2-={Testcase1}>}Testcase2),Testcase1)

Re: Re: Re: Listbox value filtration

simenkg — Fri, 01 Aug 2014 11:03:46 GMT

See attached file

The expression that I get to work:

=Aggr(only({1<TestCase2=E(TestCase1)>}TestCase2),TestCase1)

Re: Re: Listbox value filtration

muniyandi — Fri, 01 Aug 2014 11:25:41 GMT

HI simen,

Both are different filed. different table. i can select testcase1 , testcase2 at the time,or select testcase 1 only. or testcase 2 only

Ex: Sql have in condition. not In condition here possible .how to handle in the expression

Re: Re: Listbox value filtration

muniyandi — Fri, 01 Aug 2014 11:33:29 GMT

Hi Nimal,

Testcase 2 Not equal to testcase1 selected value. otherwise show full value in the list

Re: Re: Re: Listbox value filtration

perumal_41 — Fri, 01 Aug 2014 11:45:40 GMT

Hi Muni,

Try this

Re: Re: Re: Listbox value filtration

simenkg — Fri, 01 Aug 2014 11:49:59 GMT

how about:

Re: Re: Re: Listbox value filtration

muniyandi — Fri, 01 Aug 2014 11:57:23 GMT

Thanks Simen,Perumal

Re: Re: Re: Re: Listbox value filtration

Fri, 01 Aug 2014 12:13:11 GMT

Hi Mathew,

just FYI , if you do want to show both listboxes as real fields rather than expressions, you could try using on select actions.

In the attached, what you select in TestCase1 will effect TestCase2 but then you can also select in TestCase2 also, not what you are after but thought it may be useful to know.

Hope that helps

Joe