topic Selection based on filters in QlikView

Selection based on filters

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 , '|') & ')')

Re: Selection based on filters

arvind_patil — Wed, 26 Jul 2017 13:33:30 GMT

Hi Siva,

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

thanks,

Arvind Patil

Re: Selection based on filters

Anonymous — Wed, 26 Jul 2017 13:36:57 GMT

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.