Reversing filter by searching last few digits?

[user467341]

Hi all,

In normal Qlik Sense filter, if I type 123, it will filter the list to 12345, 12363, 12367, 12388.

If I type *63, it will filter 12363 (wild card infront).

My question is if it is possible not to use a wild card at the front to do this? Basically I want to search the last few digits of the data, then it will filter for me like how a wild card will do.

Thank you.

[Chanty4u]

May be this 

NewField:

LOAD *,

     Right(DataField, 2) AS LastTwoDigits

FROM data;

In filter you can give this 

= WildMatch(LastTwoDigits, '*63')

[user467341]

Hi Chanty4u,

I am using a straight table. Am i supposed to put the wildmatch inside the dimension?