Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis desired field has a ' in it.

I'm doing set analysis and my fields desired value has a ' in it.  What can I do. 

Problem:

l2hdrtxt={'SHAREHOLDERS' EQUITY'}

since there is a ' within the ' '.  It messes up the expresion.

1 Solution

Accepted Solutions
erichshiino
Partner - Master
Partner - Master

On set analysis, you could try this:

l2hdrtxt={"SHAREHOLDERS' EQUITY"}

or create an auxiliary field on your script:

Table:

Load replace(l2hdrtxt,chr(39),'') as fix_l2hdrtxt, l2hdrtxt ...

Then, on set analysis: fix_l2hdrtxt={"SHAREHOLDERS EQUITY"}

Hope this helps,

Erich

View solution in original post

3 Replies
Not applicable
Author

replace(l2hdrtxt,chr(39),'')

I have had the same issue, just not setanalysis.  The above should help get you in the right direction

Not applicable
Author

Do you know where I'd put that piece of code, marcsliving?

erichshiino
Partner - Master
Partner - Master

On set analysis, you could try this:

l2hdrtxt={"SHAREHOLDERS' EQUITY"}

or create an auxiliary field on your script:

Table:

Load replace(l2hdrtxt,chr(39),'') as fix_l2hdrtxt, l2hdrtxt ...

Then, on set analysis: fix_l2hdrtxt={"SHAREHOLDERS EQUITY"}

Hope this helps,

Erich