Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prasadmundewadi
Contributor III
Contributor III

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?

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

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

View solution in original post

12 Replies
sunny_talwar

prasadmundewadi
Contributor III
Contributor III
Author

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.

sunny_talwar

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.

sunny_talwar

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'}

prasadmundewadi
Contributor III
Contributor III
Author

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

sunny_talwar

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.

Anonymous
Not applicable

Another relevant blog:
QlikView Quoteology

Anonymous
Not applicable

"Don't quote me on this..."

Hmm...

sunny_talwar

Don't "quote" or 'quote' me on this...