Discussion board where members can get started with QlikView.
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:
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 ?
Is it possible you might have extra spaces after or before the string? May be this
View solution in original post
How about if you try this
Sorry, but no result
Thanks, It had something to do with "hidden" spaces.
May be load the field with Trim() in the script to resolve this problem