topic Re: Multiple selection in QlikView

Multiple selection

Tue, 28 Apr 2015 15:06:32 GMT

Hi all, I need to make a multiple selection.

I have several listboxes and I need that when I select a value in the first, in the second listbox appears the same value selected in green.

For example:

list box 1 list box 2

John John

anne Tony

Louis Michael

If I select John in First listbox, John appears selected in the second. In green both

Thanks so much!!

Re: Multiple selection

sunny_talwar — Tue, 28 Apr 2015 15:08:29 GMT

Are these two list boxes field connected to each other or are they totally unlinked? If unlinked then you can use Triggers to achieve what you are trying to do.

Best,

Sunny

Re: Multiple selection

sunny_talwar — Tue, 28 Apr 2015 15:14:52 GMT

See if this helps (PFA)

Use a trigger from the document properties's Trigger tab

Best,

Sunny

Re: Multiple selection

Tue, 28 Apr 2015 15:21:49 GMT

Hi,

I think if those John from two list Boxes are the same field if there are the same try to load them differently before you use them

Re: Multiple selection

buzzy996 — Tue, 28 Apr 2015 15:31:09 GMT

as sunny said,if u already linked both the tables if those are cmign frm different tables..u no need to do anythig..i.e qv default functionality,else u have to go with triggers.

Re: Multiple selection

Tue, 28 Apr 2015 15:37:34 GMT

Hi Sunindia,

my fields are COD_SM and COD_AM and this is the model tables.

Thanks!

Re: Multiple selection

buzzy996 — Tue, 28 Apr 2015 15:47:39 GMT

seems no need to use triggers here,some problem with data model..is't possible to share ur .qvw?

Re: Multiple selection

Tue, 28 Apr 2015 16:05:32 GMT

Yes @shiva qlik of course. Here you are!

Thanks!

Re: Multiple selection

buzzy996 — Tue, 28 Apr 2015 16:47:29 GMT

can u replace this script & load.. and see..

LOAD

COD_AM,

COD_SM,

COD_AM as COD_AM1,

FEC_INI_VIG as FIV_AM_SM,

FEC_FIN_VIG as FFV_AM_SM

FROM [$(vPath)QV_AM_SM.qvd] (qvd);

and use COD_AM1 as ur list box instituted of COD_AM from front end,if u need u can rename from front end the attribute name.

Re: Multiple selection

MarcoWedel — Tue, 28 Apr 2015 22:54:19 GMT

Hi,

as there seem to be no cases in your table where COD_SM is related to more than one distinct value of COD_AM, what do you want to achieve with this function ?

regards

Marco

Re: Multiple selection

Thu, 30 Apr 2015 10:45:27 GMT

Thanks to all!!!!