Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
krrohit1256
Contributor
Contributor

Filter rows for a column with multiple values

I have a column named subject.

I want to filter out records only with subjects as Maths or English.

i want to implement this in tmap.

i can use the filter expression 

row1.subject.equas("Maths") || row1.subject.equals("English")

But is there some other way because i have multiple values and not just 2 . Some thing similar to 'IN' operator

Labels (2)
1 Reply
TRF
Champion II
Champion II

You can put these values into a file, then read it with a tFileInputDelimited connected to a tMap as a lookup.

In the tMap, connect row1.subject to the lookup field to define the join between the main and the lookup rows (very basic and standard pattern). If subject are static, you can replace tFileInputDelimited  by tFixedFlowInput.