Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Select a value in field based on matching strings to use in sheet trigger

Hi All,

I want to select a value on the basis of matching strings of field value selected to use in On Leave Sheet trigger.

Eg: If value 'Pump Factory' is selected in Company Name ,then the matching string should be used to select a value to use in the trigger.

The issue is ,in each sheet report the IDs with which the Company Name are linked is different in different sheets ,hence the Company Name selection is removed when changing sheets.

Company name values are similiar in all sheets and hence i want to select on condition of string matching .

I tried the following on On Leave sheet 

if(match(Company Name),GetFieldSelections(CompanyName)),CompanyName)

on Select in Field action for Company Name field.

But it is not working,

What changes should i do? 

Thanks in advance.


0 Replies