Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

prasadmundewadi
New 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
Employee
Employee

Re: Set analysis difference between single quote and double quote

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

10 Replies

Re: Set analysis difference between single quote and double quote

prasadmundewadi
New Contributor III

Re: Set analysis difference between single quote and double quote

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.

Re: Set analysis difference between single quote and double quote

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.

Re: Set analysis difference between single quote and double quote

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
New Contributor III

Re: Set analysis difference between single quote and double quote

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

Re: Set analysis difference between single quote and double quote

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.

mov
Esteemed Contributor III

Re: Set analysis difference between single quote and double quote

Another relevant blog:
QlikView Quoteology

mov
Esteemed Contributor III

Re: Set analysis difference between single quote and double quote

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

Hmm...

Re: Set analysis difference between single quote and double quote

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

Community Browser