Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Using Like Function in load Script

i have loaded some data into QlikView but i am now trying to create a data island. i want to load previoulsy loaded data but this time only when it begins with A. To do this i have used the like function but QlikView doesn't seem to recognise it - has anyone any suggestions on what i can use - maybe something like begins with

What i currently have in my script is below

FundDataIsland:



load

Resident

FundName // NAME OF TABLE WHERE DATA WAS PREVIOUSLY LOADED

where

[Fund Name] like '%A%'; // THIS IS WHERE I AM TRYING TO TELL IT TO ONLY LOAD FUNDS WHERE THE NAME BEGINS WITH A [Fund Name] as FundIsland // FUND NAME IS NAME OF PREVIOUSLY LOADED DATA





1 Reply
pover
Not applicable

Using Like Function in load Script

Instead of the like function use

where wildmatch([Fund Name],'A*')

Regards.