Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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
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;
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;
Hi,
Thanks, its works.
Do you know Escape Operator / Sequence for Qlikview.
Regards,
Khalid
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