Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Getting Common value from QVD based on input

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?

1 Solution

Accepted Solutions
maxgro
MVP
MVP

3 Replies
maxgro
MVP
MVP

Not applicable
Author

Thanks It works as per my expectation

mansi_dv
Contributor
Contributor

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?