Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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?