Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
guyvermeiren
Creator
Creator

Qlik Sense problem set modifier with () in field value

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

1 Solution

Accepted Solutions
sunny_talwar

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

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

View solution in original post

5 Replies
sunny_talwar

How about if you try this

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

or

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

guyvermeiren
Creator
Creator
Author

Sunny,

Sorry, but no result

Kind regards,

Guy

sunny_talwar

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

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

guyvermeiren
Creator
Creator
Author

Sunny,

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

Problem solved.

Best regards,

Guy

sunny_talwar

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