Set Analysis & Single Quotes in the Element Set

jworthulf — Tue, 11 Sep 2018 14:33:07 GMT

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/SetAnalysis/set-modifiers.htm

Single quotes or no single quotes when it comes to the element set, I'm looking to clarify this as the video's I've watched on set definitely require single quotes for literals and double quotes for searches.

However, the link I'm sharing is possibly suggesting otherwise, so I'd like to get your feedback...

"Unless the listed values contain blanks or special characters, quotes are not needed. The listed values will simply be matched with the field values. This comparison is case-insensitive.

If the listed values contain blanks or special characters, or if you want to use wildcards, then you need to enclose the values in quotation marks. Single quotes should be used if the listed values are explicit field values. Then case sensitive matches between the listed values and the individual field values will be made."

So, for example, could I have

sum({$<Type = {'Shoes'}>}Sales) -- case insensitive

sum({$<Type = {Shoes}>}Sales) -- case sensitive

topic Set Analysis & Single Quotes in the Element Set in QlikView

Set Analysis & Single Quotes in the Element Set