Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Users, make your voice heard! Participate in Wisdom of Crowds® Market Study: Start Survey
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
Henric_Cronström

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

11 Replies
sunny_talwar

prasadmundewadi
Contributor III
Contributor III

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

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.

mov
Champion III
Champion III

Another relevant blog:
QlikView Quoteology

mov
Champion III
Champion III

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

Hmm...

sunny_talwar

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