topic Re: Left fxn in QlikView

Left fxn

Mon, 02 Nov 2015 15:51:59 GMT

Hi All

i have field in my table called Product_code and Customer_number

Product_code,

L140

R40

z15

a32

A201

C40

D20

T10

T01

l225

T301

A50

A54,........

Now In my Load

i need to extract the Customer_number where Product_code starts with L,l,T

Please Suggest

Re: Left fxn

sunny_talwar — Mon, 02 Nov 2015 15:54:08 GMT

Try this:

Where Match(Upper(Left(Product_code, 1)), 'L', 'I', 'T');

For the sample, the below script seems to work:

Table:

LOAD *

Where Match(Upper(Left(Product_code, 1)), 'L', 'I', 'T');

LOAD * Inline [

Product_code

L140

R40

z15

a32

A201

C40

D20

T10

T01

l225

T301

A50

A54

];

Output:

Re: Left fxn

Anonymous — Mon, 02 Nov 2015 15:55:35 GMT

Customer:

load Product_code as Customer_code

resident Products

where match(left(Product_code,1),'L','I','T') > 0

Re: Left fxn

maxgro — Mon, 02 Nov 2015 16:01:35 GMT

if you want uppercase only

where match(Left(Product_code,1), 'L','I','T')

for upper and lower

where mixmatch(Left(Product_code,1), 'L','I','T')

Re: Left fxn

MarcoWedel — Mon, 02 Nov 2015 20:36:48 GMT

another one:

Where WildMatch(Product_code, 'L*', 'I*', 'T*');

table1:
LOAD * Inline [
Product_code
L140
R40
z15
a32
A201
C40
D20
T10
T01
t02
l225
T301
A50
A54
i60
]
Where WildMatch(Product_code, 'L*', 'I*', 'T*');

hope this helps

regards

Marco