Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
jworthulf
Creator
Creator

Set Analysis & Single Quotes in the Element Set

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/SetAnalys...

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





0 Replies