If

[#1]

Hi All,

I am encountering an issue, I have a column Code in a table from OLTP, the Column values contain values like as follows:

Code

A'BC

A'AC

A'BC

When i write if(code = ' A'BC') so it considers the cotation of the middle too, is there any way to make Qlikview accept the cotation between A'BC ?

Regards,

Khalid

[#2]

Have you try to use code = "A'BC"

I think this work when you coding in edit script. But in the chart i'm not sure. Just suggession.

Regards,

Tar

[#3]

Hi,

Thanks for your idea but its not working,

Table:

LOAD * INLINE [

;

Load Code as D_Code,

if (match(Code, "A'BC"),1,0) as M_Code <----------- not working

resident Table;

[nathanfurby · Accepted solution]

Is the quotation/apostraphe character really necessary in the data? You could strip this from the values at load time?

Otherwise, if it suits your data, you could use the wildmatch function and the '?' character:

if

(wildmatch(code, 'A?BC'),1,0)

It works for me on the following load code:

TempTable:

LOAD * INLINE [

LoadCode1, D_Code1

1234, "A'BC"

6789, "A'DD"

];

Table:

LOAD

LoadCode1 as [Load Code],

D_Code1 as [D Code],

if (wildmatch(D_Code1, 'A?BC'),1,0) as [M Code]

resident TempTable;

[#5]

Hi,

Thanks, its works.

Do you know Escape Operator / Sequence for Qlikview.

Regards,

Khalid

[nathanfurby]

No I don't - I tried a couple of different combinations. This post seems to indicate that it is not possible:

http://community.qlik.com/forums/t/27442.aspx

Regards

Nathan