Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this
NewField:
LOAD *,
Right(DataField, 2) AS LastTwoDigits
FROM data;
In filter you can give this
= WildMatch(LastTwoDigits, '*63')
Hi Chanty4u,
I am using a straight table. Am i supposed to put the wildmatch inside the dimension?