Set analysis difference between single quote and double quote

[prasadmundewadi]

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?

[sunny_talwar]

Check here:

A Primer on Set Analysis

[prasadmundewadi]

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]

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]

Another relevant blog:
QlikView Quoteology

[Anonymous]

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

Hmm...

[sunny_talwar]

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