topic Re: Problem using the sting containing single qoute in QlikView

Problem using the sting containing single qoute

Fri, 03 Oct 2014 13:36:13 GMT

Hello,

I am trouble with a record name which having '

This is name of the field -------- Care Transitions (reporting Oct '14)

I wrote an expression like this :

=if(DChart='Care Transitions (reporting Oct '&chr(39)&'14)',count({< [CAHPS Count Flag]={1}, [CAHPS Chart Domain]={'Care Transitions (reporting Oct '&chr(39)&'14)'}, [CAHPS Questions Flag]={1}, [$(vDateType) $(vDateUnit)],

[Numeric $(vDateType) $(vDateUnit)]={">=$(=num(Max([Numeric Previous-x $(vDateType) $(vDateUnit)])))<=$(=Max([Numeric $(vDateType) $(vDateUnit)]))"}

>} Distinct [Survey ID]),0)

This expression is working with other filed names but not for the 'Care Transitions (reporting Oct '14)' . I tried to replace single qoute in the filed name with chr(39) but no luck.

Is there any mistake in that expression?? Please help

Thanks in advance!!

Re: Problem using the sting containing single qoute

Anonymous — Fri, 03 Oct 2014 13:38:22 GMT

Try to replace the outer single quotes with double quotes:

...Chart="Care Transitions (reporting Oct '14)",cou....

Re: Problem using the sting containing single qoute

Fri, 03 Oct 2014 13:46:24 GMT

Kim,

Thanks for your reply

Unfortunately its a name of the particular record but not a field name. But I tried with double qoutations too and it didn't help

Re: Problem using the sting containing single qoute

a_mullick — Fri, 03 Oct 2014 13:55:37 GMT

I'm not sure but in the set analysis try:

...[CAHPS Chart Domain]={"Care Transitions (reporting Oct '14"}...

or store the field name in a variable:

vFieldName = 'Care Transitions (reporting Oct ' & chr(39) & '14)'

and try:

...[CAHPS Chart Domain]={vFieldName}...

Azam

Re: Problem using the sting containing single qoute

Anonymous — Fri, 03 Oct 2014 13:56:37 GMT

I can't find an actual error in the expression, but this workaround _should_ work (if the rest of the expression is OK:

if(Replace(DChart, chr(39), '') ='Care Transitions (reporting Oct 14)

Re: Problem using the sting containing single qoute

Anonymous — Fri, 03 Oct 2014 13:57:49 GMT

But that will of course not work in the Set Analysis..