Wildmatch giving different results in Qliksense

[amol]

Hi,

I am trying to use where function in my backend where I want to see the first order only of every customer. I have used where function and wrote my code as:  where "OrderId"  like  '*_MI-1*'. 

I want the desired output as:

ABCDE_MI-1

LMNOP_MI-1

NMROT_MI-1

But instead I am getting output as:

ABCDE_MI-1

ABCDE_MI-12

ABCDE_MI-18

LMNOP_MI-1

LMNOP_MI-11

LMNOP_MI-17

NMROT_MI-1

NMROT_MI-13

My '*_MI-1*' code not only taking the first order but even showing me the results wherever 1 is shown. If I wildmatch MI-1 then MI other than 1 in the range of 1s should not be considered.

Ideas?

[anat]

can u try like Where WildMatch(col ,'*_MI-1');

[amol]

Yes, it worked. Thank you 🙂

[anat]

can u mark as complete,it will help others...