how to use wildcard in if

[n1ef5ng1]

I have this field call Load_Berth and Discharge_Berth, which is

A01

A02

A03

B01

B02

B03

First letter A and B means place such as A stands for Australia and B stands for Brazil. Basicallly this field will tell you tht this particular person was loaded to a bus at this berth and discharge at this berth

I would want to find passengers that load and berth at the same country

So my code is if(Load_Berth = {'A*'} and Discharge)Berth = {'A*'},'Intra-Country')

However it seems that it is not working,

is my wildcard usage wrong

thanks

[tresesco]

Use WildMatch() like below:

if( WildMatch(Load_Berth,'A*')  and WildMatch(Discharge_Berth,'A*') ,'Intra-Country')

[jagan]

Hi,

Try like this

if(Left(Load_Berth, 1) = 'A' and Left(Discharge_Berth, 1) = 'A', 'Intra-Country') -------------- for Australia

if(Left(Load_Berth, 1) = Left(Discharge_Berth, 1), 'Intra-Country') ------------for all countries

Hope this helps you.

Regadrs,

Jagan.

[rwunderlich]

A solution may be:

if(left(Load_Berth,1) = left(Discharge_Berth,1) 'Intra-country')

-Rob

[n1ef5ng1]

I understand that Qlikview if statement do not flow down. Meaning once A was use for the first if statement, i will not be able to use another if statement for A in the same dimension

If(Left(Load,Berth,1) = 'A' and Left(Discharge_Berth,1) = 'A','Intra-Country)

if(Left(Load.Berth,1) = 'A' and Left(Discharge_Berth,1) = 'B','Aust-Brazil')

will the second if statement flow down?

[tresesco]

Hello Bennn,

you are right, for same dimension it would not. But aren't 'Load.Berth' and 'Discharge_Berth' different dimensions ?  Please share a sample app with explained expected output.