topic Re: Getting Common value from QVD based on input in QlikView

Getting Common value from QVD based on input

Wed, 17 Sep 2014 15:35:24 GMT

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?

Re: Getting Common value from QVD based on input

maxgro — Wed, 17 Sep 2014 16:26:50 GMT

Re: Getting Common value from QVD based on input

Thu, 18 Sep 2014 08:18:41 GMT

Thanks It works as per my expectation

Re: Getting Common value from QVD based on input

mansi_dv — Thu, 25 Sep 2014 07:52:27 GMT

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?