Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

New Contributor

How do i filter or search variable possiblity

CSV data 1.JPG

Good day..

I have a Massive CSV file ( 120gb) from a database where the file is obviously no longer normalised.. I'm trying to build a filter or even just search a certain way.. if you look at the data.. there will be a . for option followed by a | for selection thereafter. now in those selections there can be a single number, or 2 3 4 5 how ever many the data gives..

I want to be able to search or filter for instance ALL subsetinv.normal|"x,x,x" meaning all subsetinv normal with 3 number selections.

how would one do that filter?

1 Reply
Valued Contributor

Re: How do i filter or search variable possiblity

Not sure how/where you want to put this, but FindOneOf (https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/Scripting/StringFunctions/Find...) could be used:

FindOneOf(BetLog.Option,'subsetinv.normal) and FindOneOf(BetLogOption,',',2)

However, best solution if loading this data into Qlik would be to divide that field into discrete fields, then standard filters/set expressions would be more direct.

see https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/LoadData/splitting-a-field.htm

Community Browser