

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Set analysis difference between single quote and double quote
As I have read "" in set analysis is user for search and '' is used for exact string.
But when I sun these set analysis both return the same result
1) Sum({$<Country={"C*"}>}Sales)
2) Sum({$<Country={'C*'}>}Sales)
Can anyone explain the difference clearly between the 2 set analysis above?
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Today there is no difference between using single or double quotes (or [...] or `...`). They will all be interpreted as quotes defining a search and not a literal match.
But just as stalwar1 points out - it is a bug. Fixing it was more complicated than we thought, so it has still not been fixed. But we are working on it right now and my guess is that we will have it fixed soon.
In the future it will work like this:
- Double quotes: Case insensitive search where * and ? are interpreted as wildcards
- Single quotes: Case sensitive string match where *, ?, =, > and ~ all are treated as any characters
HIC

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yeah this post is what confused me. So you are saying 'C*' is working because it is a bug? Ideally this won't work? because this post is from 2015 and I would imagine a bug in 2015 would be fixed by now.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I don't think it ever got fixed.... I guess HIC would want to get it fixed, but it might be so low on the list of priorities that they never actually fixed it.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Although, I am not sure, but C* might just be considered a literal as well... I have not seen clear definitions anywhere, but search might be more like this
OrderNo = {"=Count(DISTINCT Product) > 10"}
So, the above is a search string which is correct and (have not tested this) today this might work as well
OrderNo = {'=Count(DISTINCT Product) > 10'}


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Got it. If you use set analysis wizard it shows "C*" and not 'C*' hence I thought * is what search means.
Thanks for your response

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Don't quote me on this, but I don't think this is the same search as the search I just mentioned above. But hic might be able to give you a better idea here.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Another relevant blog:
QlikView Quoteology

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
"Don't quote me on this..."
Hmm...

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Don't "quote" or 'quote' me on this...

- « Previous Replies
-
- 1
- 2
- Next Replies »