topic If in QlikView

If

Mon, 21 Jun 2010 07:34:26 GMT

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

If

Mon, 21 Jun 2010 08:41:11 GMT

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

If

Mon, 21 Jun 2010 08:51:36 GMT

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;

If

nathanfurby — Mon, 21 Jun 2010 09:35:07 GMT

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:

(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;

If

Mon, 21 Jun 2010 10:18:40 GMT

Hi,

Thanks, its works.

Do you know Escape Operator / Sequence for Qlikview.

Regards,

Khalid

If

nathanfurby — Mon, 21 Jun 2010 11:12:33 GMT

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