Listbox value filtration

[muniyandi]

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.

[simenkg]

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

];

[muniyandi]

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

[simenkg]

In your second listbox do the following:

Select Expression as your field and enter the expression:

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

[muniyandi]

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

can you post , QVW file.

[#6]

Hi

Try like this

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

[simenkg]

See attached file

The expression that I get to work:

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

[muniyandi]

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

[muniyandi]

Hi Nimal,

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

[perumal_41 · Accepted solution]

Hi Muni,

Try this