topic Select same values from 2 non-associated listboxes simultaneously in QlikView

Select same values from 2 non-associated listboxes simultaneously

sifatnabil — Wed, 02 Jul 2014 07:44:56 GMT

Hi all,

I have 2 date fields from 2 completely non-associated tables, "date1" and "date2". I want auto-select the same date2 value as the one I select from the date1 listbox, e.g. selecting date1=1/7/2014 should auto-select date2=1/7/2014.

I can edit the listbox into an expression like "date1 & ' ' & date2", however this is unsightly because it just says the same date twice. Is there any other way to do this?

Re: Select same values from 2 non-associated listboxes simultaneously

Anonymous — Wed, 02 Jul 2014 07:48:29 GMT

You can use "On Select" Field Event Trigger from Document properities to achieve this.

Re: Select same values from 2 non-associated listboxes simultaneously

MK_QSL — Wed, 02 Jul 2014 07:55:11 GMT

Consider that you have two dates

Date1 and Date2

Settings >> Document Properties >> Triggers

Field Event Triggers

Select Date1

OnSelect - Add Action

Add >> Selection >> Select in Field

Field

Date2

Search String

=Date1

Do the same procedure for Date2

Re: Select same values from 2 non-associated listboxes simultaneously

ashfaq_haseeb — Wed, 02 Jul 2014 08:03:57 GMT

Hi,

Look at the attached application.

Regards

ASHFAQ