Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Selection based on filters

Guys,

I have two fields,

1. Customer_Selection and

2. Customer_EntityName


Both the fields can have same values but they are not mapped in the data model. But I needed it to be associated when any of the values is selected.


So I hve used expression in the trigger. I got it but it's working fine except one value alone, as it has some space in between the values. I think so.


Do I need to make any change on this below expression to overcome this error?

=if(GetSelectedCount(Customer_EntityName)>0, '(' & Concat(DISTINCT  Customer_EntityName , '|') & ')')

2 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Siva,

Use Apply map and map that value with correct one then you will get the full association.

thanks,

Arvind Patil

Anonymous
Not applicable
Author

Are you saying to do this by script wise? I don't want this to be mapped in the data model but based on the selection I need to associate the values.