Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

apostrophe in Set Analysis

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

Tags (1)
5 Replies
MVP
MVP

Re: apostrophe in Set Analysis

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

Not applicable

apostrophe in Set Analysis

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 :-)

MVP
MVP

Re: apostrophe in Set Analysis

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

Not applicable

Re: apostrophe in Set Analysis

Thanks!

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

Not applicable

apostrophe in Set Analysis

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

Community Browser