Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Filters with large number to match to

Hi all,

I use qlik sense and am having trouble creating a filter which includes a large number of things to match to.

I have tried the following;

IF(Match([DIMENSION HERE],'NAME HERE','NAME HERE','NAME HERE'),'PARAMATER','PARAMATER')

However I am working off a list of 4,000 possible names and it won't let me do more than 400 odd.

Any ideas?

I'm thinking that maybe I need to set up some kind of master item as this list but I'm stuck.



Thankyou!

Katherine.

2 Replies
sunny_talwar

May be do this in the script using a Mapping load?

felipedl
Partner - Specialist III
Partner - Specialist III

Just do a temporary table and use exists() statement.

Something like

// Use a temporary file or so to get all the possible values you need and load it into this table.

_tmpTable:

Load [Dimension]

From [Whatever]

DataTable:

Load *

From [Whatever]

where exists([Dimension]).