Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Is it possible you might have extra spaces after or before the string? May be this
[ExternalConditionGroups.Group 1]={"*Customer(Group)*"}
How about if you try this
[ExternalConditionGroups.Group 1]={"Customer(Group)"}
or
[ExternalConditionGroups.Group 1]={"Customer?Group?"}
Sunny,
Sorry, but no result
Kind regards,
Guy
Is it possible you might have extra spaces after or before the string? May be this
[ExternalConditionGroups.Group 1]={"*Customer(Group)*"}
Sunny,
Thanks, It had something to do with "hidden" spaces.
Problem solved.
Best regards,
Guy
May be load the field with Trim() in the script to resolve this problem