Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
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
Luminary
Luminary

Using Like Function in load Script

Instead of the like function use

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

Regards.