Getting Common value from QVD based on input

[#1]

I have set of values

LOAD * INLINE [

    CODE, NUMBER

    AA, 4

    AA, 5

    BB, 1

    CC, 1

    BB, 4

    BB, 5

    CC, 4

    CC, 5

    CC, 2

];

in the list box i present the Code. If the Code selected by user is AA,BB,CC then i need 4 and 5 in output (common for all three. 1 is missed as this is not common).

If the user selects BB and CC then 1 should also be there in the output as 1 is also common between BB and CC.

I am not able to prepare the table as this is based on dynamic user input. is there any other way to do it?

[maxgro · Accepted solution]

[#3]

Thanks It works as per my expectation

[mansi_dv]

Hi Massimo,

Can the Logic of the NUMBER table be applied in a listbox?

Or is there some expression/ trigger which can automatically select all the values in the NUMBER table as and when they are generated?