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: 
_AnonymousUser
Specialist III
Specialist III

Context variable as filter

I would like to use context variables to filter the output records on the basis of the condition which I put in context variable. 
To give and example.
My input file:
SlNo, Code
1,A
2,A
3,B
4,B
Now if my filter criteria of context variable say filter_code is A then only output records with Code A should be in output, and if B then only with Code B and if default then all the records
Labels (2)
2 Replies
Anonymous
Not applicable

you can do it using tMap configure context variable in filter expression and use something like below. 
row1.slno.equals(context.parameter) || context.parameter.equals("Default")
sunbaj
Contributor III
Contributor III

Will "Default" work  as it is not a value in the column !!