Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
erich_shiino
Honored Contributor

Set analysis desired field has a ' in it.

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

3 Replies
Not applicable

Set analysis desired field has a ' in it.

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

Set analysis desired field has a ' in it.

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

erich_shiino
Honored Contributor

Set analysis desired field has a ' in it.

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

Community Browser