Convert oracle query to qliksense script where function

[Syed17]

can anyone help me to convert this oracle ( where AAA.ATTRIBUTE5 like '75%' ) into qliksense script.

how to write this in qliksense script.

[anat]

Try using match function 

https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/Scripting/Conditiona....

[Chanty4u]

Try this

LOAD *

FROM [YourSource]

WHERE match(ATTRIBUTE5, '75%');

[vinieme12 · Accepted solution]

* is the Qlik equivalent for % in sql

WHERE WildMatch(ATTRIBUTE5, '75*')  

[MarcoWedel · Accepted solution]

there is also a "like" operator available:

https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/Scripting/Operators/...

so just replacing the wildcard % with * in your initial where clause should work as well ...