Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can anyone help me to convert this oracle ( where AAA.ATTRIBUTE5 like '75%' ) into qliksense script.
how to write this in qliksense script.
* is the Qlik equivalent for % in sql
WHERE WildMatch(ATTRIBUTE5, '75*')
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 ...
Try using match function
Try this
LOAD *
FROM [YourSource]
WHERE match(ATTRIBUTE5, '75%');
* is the Qlik equivalent for % in sql
WHERE WildMatch(ATTRIBUTE5, '75*')
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 ...