topic Field Triggers in QlikView

Field Triggers

Mon, 15 Sep 2014 10:08:56 GMT

Hi,

I have two fields connect by triggers OnSelect and OnChange:

Action: "Select Field" - DIM_A

Search String: ='("'&concat(DISTINCT DIM_B, '"|"')&'")'

I works fine except when there is no field selection on DIM_A, all DIM_B options became selected, and I don´t want that to happen..

Thanks is advance,

Francisco

Mon, 15 Sep 2014 10:13:24 GMT

I found the solution:

=if(GetSelectedCount(DIM_A)<>0,'("'&concat(DISTINCT DIM_B, '"|"')&'")')

Thanks any way...

MK_QSL — Mon, 15 Sep 2014 10:13:24 GMT

Try

='('&concat(DISTINCT DIM_B, '|')&')'