topic apostrophe in Set Analysis in QlikView

apostrophe in Set Analysis

Mon, 04 Jun 2012 08:14:55 GMT

hello everyone

i have a problem with an apostrophe in a set analysis in fact i have a list of values to consider in a field that are like this status="deleted","in progress","start","ok ' "} I can't change the value of the field "ok ' " in the database i need to make QlikView accept the apostrophe.

Thanks you kindly in advance for your responses

Re: apostrophe in Set Analysis

Miguel_Angel_Baeyens — Mon, 04 Jun 2012 08:26:35 GMT

Hi,

Try with:

{< Status = {'deleted', 'in progress', "ok*", 'start'} >}

Note how fixed literals are wraped by single quotes and search values are wraped by double quotes.

Hope that helps.

Miguel

apostrophe in Set Analysis

Mon, 04 Jun 2012 21:36:15 GMT

I hope that fixed the problem.

I have a related question; I hope I don't interfere too much (otherwise I'll open a new thread)

I wondered what the difference is between single and double-quotes in SetAnalysis. Often it gives the same outcomes. I didn't find links/documentation on that.

Is the difference that singlequotes are for text and text only and doublequotes for searchvalues?

And how about expressions and variables? I think I have seen them in singlequotes too?

I'd like to know the exact difference (or a reference where I can read about that). I hope that is also helpful for the the topic-starter 🙂

Re: apostrophe in Set Analysis

Miguel_Angel_Baeyens — Tue, 05 Jun 2012 07:47:16 GMT

Hi Roberto,

Check this post where I elaborate the difference among those three. It all summarizes in:

If numeric values, then no need for quotes
If literals / fixed strings, then single quotes
If search patterns, then double quotes

Hope that helps.

Miguel

Re: apostrophe in Set Analysis

Tue, 05 Jun 2012 11:01:53 GMT

Thanks!

Btw: I wonder if meriem.aboulaayad's problem is fixed with these answers!

apostrophe in Set Analysis

Tue, 05 Jun 2012 13:11:34 GMT

hello everyone I tried the solution above and did work! but you have to be careful roberto if you have values of the field that are different but seem similar. hope it helps you. good luck