topic Qlik Sense problem set modifier with () in field value in QlikView

Qlik Sense problem set modifier with () in field value

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

Hello,

I'm trying in Qlik Sense to define in my formula a set modifier but my field value contains ()

My set modifier is like this:

[ExternalConditionGroups.Group 1]={'Customer(Group)'}

Field value = Customer(Group)

This gives zero result

It works perfect for standard field values like 'customer A', 'Customer Belgium' ...

Has it something to do witth brackets and what is the solution ?

Thanks

Guy

sunny_talwar — Wed, 27 Jun 2018 14:42:51 GMT

How about if you try this

[ExternalConditionGroups.Group 1]={"Customer(Group)"}

[ExternalConditionGroups.Group 1]={"Customer?Group?"}

guyvermeiren — Wed, 27 Jun 2018 14:58:57 GMT

Sunny,

Sorry, but no result

Kind regards,

Guy

sunny_talwar — Wed, 27 Jun 2018 15:00:56 GMT

Is it possible you might have extra spaces after or before the string? May be this

[ExternalConditionGroups.Group 1]={"*Customer(Group)*"}

guyvermeiren — Wed, 27 Jun 2018 15:22:15 GMT

Sunny,

Thanks, It had something to do with "hidden" spaces.

Problem solved.

Best regards,

Guy

sunny_talwar — Wed, 27 Jun 2018 15:23:24 GMT

May be load the field with Trim() in the script to resolve this problem